Comparing 2 column data with other 2 columns

July 17, 2011 at 05:50:38
Specs: Windows XP
hi,
I have 2 column data to compare with another 2 columns
Eg: there is a patient number in column A and Page number in column B of about 1000 rows and other two columns also consist of the same- column C and D. i would want to compare the column A,B data with that of Column C,D to take out the odd ones.

Is there any Macro that can help me out in this comparison


See More: Comparing 2 column data with other 2 columns

Report •


#1
July 18, 2011 at 12:01:58
How is the data arrainged?

Are the Patient Nmbr and Page Number in A & B on the same row
as the Patient Nmbr and Page Number in C & D?

If they are then try this:

=IF(ISNA(AND(MATCH(A2,C2:C10,0),MATCH(B2,D2:D10,0))),"No Match","Match")

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question