Excel Problems

Do your own homework

>>1328325
1) copy/paste both columns into one column in a new spreadsheet
2) check for duplicates

not the fanciest way to do it but it works.

>>1328335
OP on suicide watch

Make a third spreadsheet for yourself, combine columns, check for duplicates

>>1328325
There's some behavior you can add to the cells to check for duplicates

>>1328338
>>1328347
>>1328414
>doing it the pleb way

There's a function that will do it, interns

Two, actually

>>1328519
Then enlighten us with your wisdom, Einstein

>>1328534
Vlookup

Alternatively, Index Match is a bit more flexible, but Vlookup will do the job in most cases, very very useful formula to learn

>>1328325
Dude. Didn't you start a thread to ask this exact question over on /g/ about two days ago?

I'm sure I remember something like this.

>>1328325

Google this shit yourself.

That's how I've learned everything, and my colleges/co-workers think I'm a fucking Excel wizard. In reality, any time I tried to do something fancy, I just spent time bouncing around on Google until I found an answer.


Now I can do the equivalent of light programming in Excel.


>>1328541
Once you understand the basics of Index(Match), you should ditch VLookUp and HLookUp all together. It's too flexible not to.

File: aaaaaa.png (46KB, 676x544px) Image search: [Google]

46KB, 676x544px

>>1328541
>Index Match

This is what I'm using it for currently. I think VLookup would work here too, but it's easier when I have to keep copy-pasting this formula across a ton of time frames.