By Andy Robinson in excel —

Excel last row

Excel last row
Photo by Mika Baumeister / Unsplash

Check if the current row is the last row in a set of data

IF(MATCH(REPT("z",50),A:A)=ROW(),"VALUE FOR LAST ROW","VALUE FOR OTHER ROWS")

I found the way to find the last row here. It's basically generate a string of z's (50 of them) and then tries to find that in your data (A:A) as it can't find that it returns the last row.

I use this to generate SQL scripts and I want the last entry to be slightly different e.g. UNION ALL etc