Whats the correct formula to point to the last populated cell in a column?

		Microsoft Office Forums > Microsoft Excel > Excel
Whats the correct formula to point to the last populated cell in a column?

03-08-2021, 10:32 PM

Purfleet

Windows 10 Whats the correct formula to point to the last populated cell in a column?

Office 2019

Expert

Join Date: Jun 2020

Location: Essex

Posts: 345

How about an index & match

Code:

=INDEX(D:D,MATCH(TODAY(),A:A,0))-INDEX(D:D,MATCH(TODAY(),A:A,0)-1)

Attached Files

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
IF cell in Col A is populated BUT cell in Col C is blank DELETE ROW	ChrisOK	Excel Programming	7	05-05-2019 09:00 PM
Filling a formula down a column where only one cell value referenced changes?	sakurasanta86	Excel	1	08-27-2018 03:23 AM
formula help - value in cell looking up row and column using great than less than	stefano	Excel	3	10-20-2017 02:20 PM
Entering a column value in a cell, to be used as part of a reference in a formula in another cell	paulkaye	Excel	4	02-26-2017 04:18 AM
Creating formula based on if data is correct in cell	MattMurdock	Excel	1	08-06-2012 03:11 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:04 PM.