Forum Discussion
Solved
Return last number in a column
Hello All I am pretty new to excel and i got a problem i cant seem to figure out no matter how many posts about it i have read. Ultimately i want to make excel show me the last number in a ...
Do you use comma as decimal separator (e.g. three-and-a-half is 3,5)?
If so, you should use semi-colons instead of commas in the formulas:
=LOOKUP(9,99999999999999E+307;G9:G28)
and
=LOOKUP(2;1/(G:G<>0);G:G)
Use
=LOOKUP(9.99999999999999E+307,G:G)
You can use a finite range instead of the entire column, of course.
The last non-zero number is
=LOOKUP(2,1/(G:G<>0),G:G)
Thanks for the quick reply.
What im experiencing seems to be something else. Even when i past those formulas they produce the same error as on the picture.
Do you use comma as decimal separator (e.g. three-and-a-half is 3,5)?
If so, you should use semi-colons instead of commas in the formulas:
=LOOKUP(9,99999999999999E+307;G9:G28)
and
=LOOKUP(2;1/(G:G<>0);G:G)
