Hi all,
I have a problem that I cannot get my head around, I was wondering if anyone had any insight;
I have a list on 'sheet1' column A - listing say fruits. This list is dynamic and changes on user selection- it can be longer or shorter.
A
Banana
Cherry
Dragon fruit
On 'sheet2' column A, I have many unsorted duplicates of the same text (fruits), each with their own individual data in adjacent rows - lets say weight in column B:
A B
Fruit Weight
Apple 52
Apple 48
Banana 120
Grape 7
Grape 7
Cherry 10
Apple 52
Banana 127
Cherry 11
Dragon fruit 700
I want to pull all instances of fruits in 'sheet2' that appear in sheet1 column A, and paste them in a sorted fashion in a column without any spaces.
So in this case
Banana 120
Banana 127
Cherry 10
Cherry 11
Dragon fruit 700
In a nutshell, the purpose of this is to return all data in a single column for those fruits which a user has selected.
There are over 15000 rows in the data set and for some reasons it is not feasible to re-sort the data in Sheet2.
How might one get excel to pull all text duplicates from a list based on another list of text values?
I tried offsetting an index match, but the offset needs to be dynamic and take into account many duplicates, and duplicates the sheet has already returned, and I cannot figure out how to do so.
Any help is much appreciated!
Bookmarks