Data Compare
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. |
Data Compare
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 |
Data Compare
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") "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. Many thanks. |
Data Compare
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 --- "leerem" wrote: 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") |
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 "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 |
Data Compare
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 --- "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 |
All times are GMT +1. The time now is 09:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com