Thread: [Solved] Whats the correct formula to point to the last populated cell in a column?
View Single Post
 
Old 03-08-2021, 10:32 PM
Purfleet Purfleet is offline Windows 10 Office 2019
Expert
  
Join Date: Jun 2020
Location: Essex
Posts: 345
Purfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to beholdPurfleet is a splendid one to behold
Default
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
File Type: xlsx Copy of sample for micosoft forum_purfleet.xlsx (14.9 KB, 4 views)
Reply With Quote