Amit has attended:
Excel Intermediate course
Comparing data within 2 spreadsheets
If you have two sets of data and they contain some similar values, but not in any particular order, how can you find common entries within the 2 sets of data?
RE: Comparing data within 2 spreadsheets
Hi Amit, Thank you for the post, welcome to the forum, in answer to your question, I would consider using the =EXACT( formula, however this will only check one cell against another, if the two lists are in columns and are next to each other ie Column A and Column B, in Column C place the formula =EXACT(A1,B1) this will compare the value in A1 with the value in B1 if they are the same it will return TRUE if not FALSE, you could then copy the formula down the list to check all your entries (Double click the fill handle). Note: This will also work with text entries.
I realise that I have given an example on just one worksheet but cross worksheet (3D) formulas will work as well.
If this is not what you are looking for, please come back and we can discuss it in more detail, if this has answered your question, please click the Resolved link, best regards Pete
RE: Comparing data within 2 spreadsheets
Hi Pete,
There may be data that is in one column, but not the other and vice versa.
e.g. Column A may have:
aaab
aaad
aaae
and Column B may have:
aaaa
aaab
aaac
How can you check that aaab is in both Column A and B, and find other text that is in both Column A and B?
Thanks
Amit
RE: Comparing data within 2 spreadsheets
Hi Amit, Thanks for your response, I still stick by my original answer, it is the only way that I can think of that will sort out your problem. regards Pete