- My Forums
- Tiger Rant
- LSU Recruiting
- SEC Rant
- Saints Talk
- Pelicans Talk
- More Sports Board
- Fantasy Sports
- Golf Board
- Soccer Board
- O-T Lounge
- Tech Board
- Home/Garden Board
- Outdoor Board
- Health/Fitness Board
- Movie/TV Board
- Book Board
- Music Board
- Political Talk
- Money Talk
- Fark Board
- Gaming Board
- Travel Board
- Food/Drink Board
- Ticket Exchange
- TD Help Board
Customize My Forums- View All Forums
- Show Left Links
- Topic Sort Options
- Trending Topics
- Recent Topics
- Active Topics
Started By
Message
Excel Question - Removing all duplicate names - SOLVED
Posted on 11/30/20 at 4:21 pm
Posted on 11/30/20 at 4:21 pm
I have 2 columns of company names.
Column A has roughly 1,000 companies
Column B has roughly 300 companies
Every company in column B is in column A
I want to create a column C with the other 700 companies.
So my question is how do I generate a list for column C that only contains names not duplicated in column B?
I am pretty well versed in Excel but I'm having a complete brain fart on this one. I know there's got to be a simple way to get this list.
Column A has roughly 1,000 companies
Column B has roughly 300 companies
Every company in column B is in column A
I want to create a column C with the other 700 companies.
So my question is how do I generate a list for column C that only contains names not duplicated in column B?
I am pretty well versed in Excel but I'm having a complete brain fart on this one. I know there's got to be a simple way to get this list.
This post was edited on 11/30/20 at 4:53 pm
1
Posted on 11/30/20 at 4:30 pm to CAD703X
Manually or auto?
Manually set up a vlookup that highlights dupes in column A. Then filter on color. Copy remaining names to column c.
Manually set up a vlookup that highlights dupes in column A. Then filter on color. Copy remaining names to column c.
This post was edited on 11/30/20 at 4:31 pm
Posted on 11/30/20 at 4:36 pm to mchias1
yep! you got it!! 
=IF(ISERROR(VLOOKUP(A2,$B$2:$B$270, 1, FALSE)),"Non-duplicate","Duplicate" )
just flow this down to pick up every record in column A.
that will do the trick. Ugly & not elegant but quick way to get what I've been asked for. just resorted by 'duplicate' v non-duplicate' and pulled those names out.
the vlookup was the thing i was trying to think of.
=IF(ISERROR(VLOOKUP(A2,$B$2:$B$270, 1, FALSE)),"Non-duplicate","Duplicate" )
just flow this down to pick up every record in column A.
that will do the trick. Ugly & not elegant but quick way to get what I've been asked for. just resorted by 'duplicate' v non-duplicate' and pulled those names out.
the vlookup was the thing i was trying to think of.
This post was edited on 11/30/20 at 4:52 pm
Posted on 12/1/20 at 9:34 am to CAD703X
why not just highlight both columns and conditional format for duplicates then filter for un-highlighted cells?
everyone always trying to use vlookup. It is outdated now as well with the introduction of xlookup
everyone always trying to use vlookup. It is outdated now as well with the introduction of xlookup
This post was edited on 12/1/20 at 10:01 am
Posted on 12/1/20 at 10:25 am to deNYEd
quote:
deNYEd
where the hell have you been??
Posted on 12/1/20 at 11:44 am to deNYEd
quote:I'm embarrassed that I did not know this. No more cut insert columns when the shite you're looking in a column AFTER.
xlookup
Page 1 of 1
Popular
Back to top
Follow TigerDroppings for LSU Football News