- 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 help - need a formula to show missing people
Posted on 8/15/18 at 11:03 am
Posted on 8/15/18 at 11:03 am
I have two spreadsheets of employees from different dates
I need to figure out who is not on the most recent list. I was thinking I could put in a formula comparing social security numbers
can anyone suggest how this would best be achieved?
please and tia!
I need to figure out who is not on the most recent list. I was thinking I could put in a formula comparing social security numbers
can anyone suggest how this would best be achieved?
please and tia!
4
Posted on 8/15/18 at 11:25 am to Paige
Posted on 8/15/18 at 11:39 am to sfdurst
I think remove duplicates would work but that looks really complex and possibly over my head
I tried to just do highlight duplicates but there’s over a thousand rows on each spreadsheet and it was confusing
I tried to just do highlight duplicates but there’s over a thousand rows on each spreadsheet and it was confusing
Posted on 8/15/18 at 12:14 pm to Paige
Use COUNTIF
formula would be like:
=COUNTIF(A1,B$1:B$99999)
Then drag down to bottom and then copy, paste values and filter to 0s
formula would be like:
=COUNTIF(A1,B$1:B$99999)
Then drag down to bottom and then copy, paste values and filter to 0s
Posted on 8/15/18 at 12:18 pm to Paige
Vlookup the old list onto the new list (by SSN) and filter the results on "#N/A"
Hope that helps!
Hope that helps!
Posted on 8/15/18 at 12:19 pm to lsu02150
thank you
I got it
I got it
Posted on 8/15/18 at 12:19 pm to NCTiger17
that's exactly what I did
great minds!
great minds!
Posted on 8/15/18 at 12:20 pm to Paige
Posted on 8/15/18 at 1:21 pm to NCTiger17
quote:
Vlookup
Best function ever.
Posted on 8/15/18 at 6:37 pm to Paige
I was going to say to do the vlookup
The same function in access is a little easier with linked tables but sometimes you have to slum it and use excel
The same function in access is a little easier with linked tables but sometimes you have to slum it and use excel
Posted on 8/16/18 at 5:13 pm to Paige
Pivot table. Sort by names.
Page 1 of 1
Back to top
Follow TigerDroppings for LSU Football News