M
Meg
I have two separate spreadsheets of data both have an ID# attached to each
row of data which I need to match.
The first spreadsheet has lots of data of information and these ID#s may or
may not repeat depending on how many products one ID may have.
The second spreadsheet has all the ID#s which I need to review. I'd like to
remove any identifying numbers from the first spreadsheet that do not appear
on the second spreadsheet and only keep the matching ID#s.
How can I do this?
Thank you!
row of data which I need to match.
The first spreadsheet has lots of data of information and these ID#s may or
may not repeat depending on how many products one ID may have.
The second spreadsheet has all the ID#s which I need to review. I'd like to
remove any identifying numbers from the first spreadsheet that do not appear
on the second spreadsheet and only keep the matching ID#s.
How can I do this?
Thank you!