Hello,
I've attached a sample doc to work from.
I'm using an array formula to index a list, and pull the unique values that match the criteria.
The main thing I am hoping to solve is: getting the same result as I have in the sample doc, without using an array formula - is that possible? I want to pull in the 'feature' listed next to each person and populate in a list on a separate sheet.
Second to that, it seems for some reason my formula as is, is taking the 'feature' assigned to a person that is one row up. If you look at 'person 3' in sheet1, the first feature is 'feature1TEST'. However that is in line and should be designated under Person 2, not person 3 and I am not sure why.
Thank you,
kaunck
Bookmarks