Hi all,
I have a dataset that i want to extract from. It looks like this:
Country Data
US A
UK B
US C
UK D
US E
I want to use the identifier US to pull out all US data. However, as i'm doing it now, I'm getting
US A
US A
US C
US C
US E
I would like to just get
US A
US C
US E
I hope this is clear.
If you have your data in the range "A2:B6" try below formula in C2, copy and paste formula C2:D6
Please Login or Register to view this content.
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Without seeing a sample spreadsheet, the best I can offer is that you go to Data--Sort & Filter--Advanced and then use the built in function of Excel to find the Unique values.
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Please try at D1 > US
D2:E2 copy down
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($B$2:$B$99)/($A$2:$A$6=$D$1),ROWS(D$2:D2))),"")
This works like a charm! Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks