Hi
I have been trying for a while now to get lookup to work with zero's.
I have a row as below that has data entered over a period of time. I need the last entry in this case 0.67. But cannot get lookup to work because of the zero's that have to be there.
0.79 0.79 0.89 0.65 0.55 0.67 0.78 0.67 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
Thank you for any help
Bookmarks