Hi,
This question will probably be easy to some of you.
Sheet A
Column 1 - Unique Values
Column 2 - Mixed Values some Duplicates some Unique
I have a list of values I want to lookup in Column 2, my list has duplicate values, for each duplicate value in the List it relates to an entry in Column 2 which relates to the Unique Value in Column 1.
I want to be able to extract all the unique values in a Lookup/Match scenario, I guess it will be using some form of COUNTIFS and MATCH INDEX but I haven't been able to work it out.
Your help is greatly appreciated.
This question will probably be easy to some of you.
Sheet A
Column 1 - Unique Values
Column 2 - Mixed Values some Duplicates some Unique
I have a list of values I want to lookup in Column 2, my list has duplicate values, for each duplicate value in the List it relates to an entry in Column 2 which relates to the Unique Value in Column 1.
I want to be able to extract all the unique values in a Lookup/Match scenario, I guess it will be using some form of COUNTIFS and MATCH INDEX but I haven't been able to work it out.
Your help is greatly appreciated.