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<[email protected]> 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: [email protected] For additional commands, e-mail: [email protected]
