So one obvious, but not very generic solution was to realize that the data always starts with the value 1 in cell A3, so =MAX(A3:A10000) returns the highest value and I can add 2 to that to get the row address.
I'd rather find a more interesting and generic solution to this though as I don't always have a value incrementing in the first column. Thanks, Mark On Wed, Jun 24, 2009 at 10:34 AM, Mark Knecht<markkne...@gmail.com> wrote: > If it helps the first column is a line number so it just increments > from 1 to whatever the final value is. Maybe some sort of fancy dual > VLOOKUP that somehow find the first place the next value isn't larger > than the current value? > > Don't know. > > On Wed, Jun 24, 2009 at 10:31 AM, Mark Knecht<markkne...@gmail.com> wrote: >> Hi, >> I wonder if anyone knows of a function I might use to find the row >> number of the last non-blank cell in a column? >> >> I have data that I paste in which comes from another source. >> Depending on what the other source is doing the data pasted in is >> different in length. I need to automatically determine when this data >> ends. >> >> Thanks, >> Mark >> > --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org
