Hi,
plz see the file.
Hi,
plz see the file.
Hi it worked..how to make it entire column as reference (without specifying up to specific range)?
Hi,
in cell B2 put the below formula
=ISNUMBER(MATCH(A2,'MRN IS INCORRECT'!A:A,0))
I have a followup question
Now I have to 2 files and I want to compare filename "Published" under worksheet "Correct MRN Sorted By MRN" Column B with filename "ALLMRN" sheets 1 to 4.
If the numbers in sheets 1 to 4 exist in "published" column B, it will return a value under Exist column as TRUE, if not exist FALSE
is it possible for multiple worksheets and separate files?
Hi,
You have to create a Sheet List. Then Put the below formula in Cell D2 (Published File)
=IFERROR(MATCH(1,--(COUNTIF(INDIRECT("'"&SheetList&"'!$A$2:$A$1000"),B2)>0),0)=1,"False")
Ctrl+Shift+Enter
Note: Both file should be open.
is it normal for processing takes time? sometimes if freezes![]()
Bookmarks