Identify last row of populated data
 

Last piece of data in column F (numeric or text):
=LOOKUP(2,1/(F1:F65535<""),F:F)

Last numeric value in column F
=LOOKUP(MAX(F:F)+1,F:F)


"Jumbo Shrimps, Jr." wrote:

Have 12 rows of linked cells,
one for each month of the year.
End of the month, data for March, for
example is updated through a link to another
spreadsheet.
Months April - Dec have no data yet.
Two rows below the bottom of the twelve rows, is a simple
division calc, dividing cells D2/G2, for example.
At the end of the month I have to change the formula
(row 2 last month), to row 3 (D3/G3) for March,
next month same thing (D4/G4) until the end of the year.

Is there a lookup function that identifies the LAST
row of populated data in an array of data rows 1 - 12
and then performs the division?

Row
Jan 1
Feb 2
March 3
April 4
May 5
June 6
July 7
etc.

Identify last row of populated data
 

Have 12 rows of linked cells,
one for each month of the year.
End of the month, data for March, for
example is updated through a link to another
spreadsheet.
Months April - Dec have no data yet.
Two rows below the bottom of the twelve rows, is a simple
division calc, dividing cells D2/G2, for example.
At the end of the month I have to change the formula
(row 2 last month), to row 3 (D3/G3) for March,
next month same thing (D4/G4) until the end of the year.

Is there a lookup function that identifies the LAST
row of populated data in an array of data rows 1 - 12
and then performs the division?

Row
Jan 1
Feb 2
March 3
April 4
May 5
June 6
July 7
etc.

Identify last row of populated data
 

=LOOKUP(9.99999999999999E+307,Range)

Jumbo Shrimps, Jr. wrote:
Have 12 rows of linked cells,
one for each month of the year.
End of the month, data for March, for
example is updated through a link to another
spreadsheet.
Months April - Dec have no data yet.
Two rows below the bottom of the twelve rows, is a simple
division calc, dividing cells D2/G2, for example.
At the end of the month I have to change the formula
(row 2 last month), to row 3 (D3/G3) for March,
next month same thing (D4/G4) until the end of the year.

Is there a lookup function that identifies the LAST
row of populated data in an array of data rows 1 - 12
and then performs the division?

Row
Jan 1
Feb 2
March 3
April 4
May 5
June 6
July 7
etc.