So you want to be a /biz/nessman?
Let's test your excel knowledge.
Let's start with an easy one:
I have two different spreadsheets, SS1 and SS2. Each have 1 column of names.
How do I ensure that no name from the SS1 name column is in SS2's column?
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
>>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.
>>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.
