Data Compare

[SiH23]

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.

Many thanks.

 

[Max]

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

 

[leerem]

yes,
if the data to be checked is Text then
enter this into Cell M3 if data to be checked is in cell E3

=IF(ISTEXT(E3)=TRUE,"Y","N")

if Numeric then IF(ISNumber(E3)=TRUE,"Y","N")

 

[Max]

If you re-read the query, think the OP wants col E to be compared with what's
in col M, with the answer placed in col J.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:20,500 Files:365 Subscribers:65
xdemechanik

 

[SiH23]

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]

Do me a favour. Close off this thread for the record by pressing the YES
button (like the one below) in the earlier response since you got the answer,
albeit you omitted mention of it in your feedback.

As for your new query below, well you've correctly re-posted it afresh in a
new thread ..
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:365 Subscribers:65
xdemechanik