Hi,
While i'm comfortable with excel, I don't know some of the common workarounds, and while I've found some solutions that may fit here, there wasn't any accompanying description so I thought i'd post something new.
What I need is to have a function which will match something from one column and return a value from another.
I have been using index & match to do this - but it does not handle duplicates. I will have many, legitimate duplicates, and I require them to show up as well.
My basic need is this. I have 3 columns to check and order. Each ordered list (1 for each column) will also have to reference the correct value from the 1st column.
So lets say steve and bob both have a value of '4'. In the list that compiles that column, I would need both steve and bob to be represented. My current setup of index & match will show the two '4' values (I use large()), but will only match the first name it finds.
If the formula is long I would appreciate if you explained it so I will be able to mold it to my needs.
My current function is : =INDEX(A:A,MATCH(LARGE(B:B,ROW()-1),B:B))
thanks for your help
Bookmarks