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