Finding the last row in dataset

B

Bo Rasmussen

Hi,

Suppose I have a dataset of varying length (i.e. number of rows) - how do I
use a worksheet function to figure out the rownumber of the last dataitem.
I'm creating an analyser for some datacommunication, and need some values
from the last row.

Regards
Bo Rasmussen
 
F

Frank Kabel

Hi
if you want a worksheetfunction for returning the last
value try
=LOOKUP(2,1/(1-ISBLANK(A1:A1000)),A1:A1000)
 
Top