Hi, I'm really struggling with trying to find the last value in a column. The formula below used to works in a different sheet until you go to copy the formula then returns a #VALUE! error which seems to originate from the highlighted bit.
=INDEX(H$10:H$15,LARGE(IF(H$10:H$15<>"",ROW(H$10:H$15)-MIN(ROW(H$10:H$15))+1),ROWS(H$16:H$16)))
Any ideas???
Nathanael
I tried that but it doesn't return a value.
Last edited by natdawson; 05-10-2010 at 05:25 AM.
hi natdawson
It will return the last value in column H
what did you get
it didn't return anything.
I'm looking for something which will look up the column from the current cell say H9 in this case and keep going til it finds the first value which in this case would be '597809'.
H
1
2 1278463
3 937289
4 392742
5 1000398
6 597809
7
8
9 value returned here
try this one, it finds the last number in a column
=LOOKUP(9.99999999999E+307,h:h)
the other formula is for the last word or number
Excellent, just altered the h:h bit but now works perfectly.
Many thanks
Nathanael
no problems , but dont forget to mark the post solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks