Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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") |
#5
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 "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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compare 2 data set | Excel Worksheet Functions | |||
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 |