How is the blank cell assigned a number?

Do you want the row number of the first blank cell returned?

=MATCH(99^99,A:A) + 1 if data is numerical

=MATCH(REPT("z",255),E:E) + 1 if data is textual


Gord Dibben MS Excel MVP


On Tue, 11 Aug 2009 12:37:01 -0700, CHOUSE - UCITY <CHOUSE -
wrote:

I have 2 spreadsheets that need to be linked. This is what I need:
Spreadsheet A has a basic log of information. The information is logged in
rows which each have an assigned number. This number needs to be linked to
spreadsheet A. However; Each time information in logged into spreadsheet A,
the formula needs to pick up the NEXT BLANK CELL's assigned number.