|
If for example the data is in column A of both spreadsheets, in the latter spreadsheet put in this formula in an empty col row 1 then fill down: =IF(COUNTIF('Older Spreadsheet'!A:A, A1) > 0, "Y", "N") so its just a Y/N of if the value in the later spreadsheet is in the old one. |
#4826947, By Twinkle *Official* Excel help thread
-
Twinkle 542 posts
Seen 3 years ago
Registered 17 years ago
