M
Mr. Low
Hi.
Lets consider the following table:
A B
1 <------ Last item of the column either text
or number
2 Amount Amount
3 250 125
4 500 365
6
5 120 not found
1500 350 458
5000 500 too costly
Total 3250 2560
Result Fair
The column A and B has both text , numbers and blank cells, May I know the
formula to pick up the last item for ach column.
Let the output be in cell A1 and B1 respectively.
I try using =lookup (“zzzzâ€, A2:A500), but it does not work.
Kindly provide guidance
Thanks
Low
Lets consider the following table:
A B
1 <------ Last item of the column either text
or number
2 Amount Amount
3 250 125
4 500 365
6
5 120 not found
1500 350 458
5000 500 too costly
Total 3250 2560
Result Fair
The column A and B has both text , numbers and blank cells, May I know the
formula to pick up the last item for ach column.
Let the output be in cell A1 and B1 respectively.
I try using =lookup (“zzzzâ€, A2:A500), but it does not work.
Kindly provide guidance
Thanks
Low