PLEASE HELP!! I NEED THIS FOR WORK!
I am trying to compare 2 table contained by excel.
Heres my set up:
Table 1 contains elderly entries. Table 2 contains spanking new entries and dated entries from table 1.
How can i go through to see if the entries surrounded by table 2 are originally also in table 1?
I requirement to find out if the notes surrounded by table 2 is also somewhere within table 1.
There is individual 1 column, let lately say aloud "phone number"
i want to compare the 2 table and see which ones are unmarked entries surrounded by table 2 and which ones are behind the times entries from table 1 contained by table 2.
The table don't even entail to enjoy like peas in a pod amount of entries.
I newly want to know, contained by table 2 which items are untried, which ones are matured.
PLEASE HELP!! I NEED THIS FOR WORK!
By boss give me 2 table beside over 4300 entries within respectively and he desires me to verify the notes resembling i mentioned. I will not try to use the find substitute, because i would hold to do it 4300 times. That'll be a huge headache.
Answers: I would create a topical sheet
In the A row of the foreign sheet attach the first table
In teh B Row stick the second table
In C1 cement contained by =IF(A1=A2),,"DIFFERENT")
Grab the block contained by the bottom right corner of C1 and drag it downwards to replicate the formula for adjectives the other cell.
Any cell next to differences should hold the word "DIFFERENT!" printed in the C Row
Hope this help,
teef_au
pls try this link
http://office.microsoft.com/en-us/market...