Thread: [Solved] List of N last cells
View Single Post
 
Old 06-17-2021, 09:37 AM
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
Not the best, but a start

for 3 - =INDEX(A:A,MATCH(TRUE,A:A="",0)-ROWS(C1:$C$3))
for 6 - =INDEX(A:A,MATCH(TRUE,A:A="",0)-ROWS($C1:C$6))
Attached Files
File Type: xlsx List of N last cells_ar12.xlsx (9.9 KB, 9 views)
Reply With Quote