Hi Mandeep,
I don't know how to use VLookUp function for my situation. I was wondering
whether would you mind showing me how to use VLookUp function according to
my code?
Cheers
On Monday, 22 February 2016 20:57:58 UTC+8, Mandeep baluja wrote:
>
> Will you please let me know why you're not
Hi Paul,
Not certain what changed, but I set my system date as yours (M/D/) and
everything is miraculously back to normal.
Thanks.
On Monday, 22 February 2016 14:51:28 UTC-5, Paul Schreiner wrote:
>
> Your earlier description/expectation seems faulty:
> Looking at the .csv file, the
Thank you so much, Paul, for sharing your expertise with me.
You made it very clear.
M.P.
On Tuesday, February 23, 2016 at 12:06:14 PM UTC-5, Paul Schreiner wrote:
> This version of Excel has 16,384 columns and 1,048,576 rows.
> The worksheet you've provided has those "extraneous" cells
Thank you so much, Norman, for sharing your expertise with me.
M.P.
On Monday, February 22, 2016 at 7:31:14 PM UTC-5, Norman wrote:
> Select the upper left corner of the worksheet. Above row 1 and the the
> left of column A. This will select the entire worksheet. Right click any of
> the row
It would be helpful to provide a sample file.But:What version of Excel are you
using?
Where do you get the values for column "O"? Your example has entering "utility"
when something other than "fuel" is in column J.Are there other values?
And, what so you mean by "Delete any extra line after the
In cell G4, enter formula:=SUMIF(C$4:C4,F4,D$4:D4)and copy the formula down
through column G.
The "$" means that the beginning row of the range is "anchored" which means
that the first row of each range is 4,but the ending row of each range will
increment to match the "current"
Hello All,
Please I need help with the below macro.
I have a worksheet with lots of data.
1.
I want to go through each cell in column J.
To find data and put the answer in column O.
2.
Then left and Right trim spaces
3.
Delete any extra line after the
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help,
