Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and the Yahoo Answers website is now in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.
Trending News
How To Remove Excess Data From Excel?
I got 2 Excel Sheet now i want to take Unique ID Column from one to Filter the needed from the Bigger Data Base Excel File to get Result with that column match only.
Like I will use unique id from smaller to Filter and Get All the bigger From the ALL people Data to match and keep those people's Data and remove the other?
2 Answers
- expletive_xomLv 76 years agoFavorite Answer
if the unique id is on both sheets, then you can probably just use a COUNTIF() function.....then filter the bigger.
if the unique id is not on the Bigger Data Base, then you might have to use a VLOOKUP() or INDEX() and MATCH() to put the unique id on the bigger.
if you want a specific formula, then a sample or an example would be needed.
- 6 years ago
Update what i End up using was Index(N:N , Match (L2,O:O))
N was The Field to get Data
L2 Was unique identifier
O was the row of other Data's Unique Identifier
But i had to get Use one by one to get all the Column
