Function Question
Posted by Chuck Burns on September 07, 2001 10:38 AM
How do I return the last value in a column?
1
2
3
The function would return a "3", from above.
Chuck
Posted by Aladin Akyurek on September 07, 2001 10:57 AM
Chuck,
If your range of data of numeric type, use
=INDEX(A:A,,MATCH(9.99999999999999E+307,A:A))
where I assume your data to be in column A.
Aladin
=============
