In MS Excel:
I have two lists of about 3,000 account numbers each. I want to merge them. The tricky part is that I want to pull only the account numbers from the second sheet which are not already on the first sheet. Is there any way to get Excel to check that the account # is not already represented? I would normally just cut/paste/sort and then cut out the duplicates, but with lists so large I’m hoping that there is a quicker way.
DaLovin’ Dj
Here’s one way:
[1] Merge the two lists into one giant list.
[2] Sort alphabetically.
[3] Put a comparison statement in the next column so that there’s a “Yes” or something if two consecutive values are equal.
=if(a1=a2,"Yes","")
[4] Copy the comparison column and paste as values.
[5] Sort on the comparison column and delete all the rows with “Yes”.
Oops. I just realized I basically told you what you didn’t want to do. Oh well, maybe my formula method will at least help so you don’t have to do it all manually.
That helped alot. Thanks for the lighting quick response. The whole thing takes about 2 minutes now. You know, it’s times like these that justify the hundreds of hours I spend goofing around on the net at work. Sure, it may look like I’m slacking off, but in reality I’m expanding my resources and improving efficiency. Nice little trade. I get to slack off and they get to have an employee who knows where to find new and useful information quickly and effectively. Once again, the SDMB is my secret weapon!
DaLovin’ Dj
That helped alot. Thanks for the lightning quick response. The whole thing takes about 2 minutes now. You know, it’s times like these that justify the hundreds of hours I spend goofing around on the net at work. Sure, it may look like I’m slacking off, but in reality I’m expanding my resources and improving efficiency. Nice little trade. I get to slack off and they get to have an employee who knows where to find new and useful information quickly and effectively. Once again, the SDMB is my secret weapon!
DaLovin’ Dj