Excel last row 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