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
"Max" wrote:
Certainly, here's one way
Assuming data in row2 down
In J2: =IF(E2="","",IF(COUNTIF(M:M,E2),"Y","N"))
Copy J2 down all the way to the last row of data in col E
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik
---
"SiH23" wrote:
Is it possible to compare the data in each individual cell in Column E with
that in Column M. If the data in the cell in Column E is present in Column M
then place either a Y or N in Column J