Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Compare
Is it possible in excel to run a search that checks if the details in 2 cells
of a row occur together again in the any row but different columns. for instance: D2 = JOE E2 = BLOGGS Check if JOE is present anywhere in column M with BLOGGS also present in that same row in column N |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data Compare
If
=SUMPRODUCT((M1:M1000=D2)*(N1:N1000=E2)) is greater than 0, then the match exits somewhere in the columns AutoFilter can tell you exactly where the match(es) occur. -- Gary''s Student - gsnu200820 "SiH23" wrote: Is it possible in excel to run a search that checks if the details in 2 cells of a row occur together again in the any row but different columns. for instance: D2 = JOE E2 = BLOGGS Check if JOE is present anywhere in column M with BLOGGS also present in that same row in column N |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
compare data | Excel Discussion (Misc queries) | |||
Compare data and automatically enter data. | Excel Discussion (Misc queries) | |||
how to compare a list of data that is same as the main data sheet | New Users to Excel | |||
COMPARE DATA FOR CHANGES | Excel Worksheet Functions | |||
Compare Data | Excel Worksheet Functions |