dynamic list of unique values

**td3201** · 12-13-2017, 07:11 PM

I have a list of non-unique values in Plays!E2:E73. I'm able to get a list of unique values with this formula:

Please Login or Register  to view this content.

However, I'd like to put a conditional on them that says Plays:I of that particular row = Yes. I'd appreciate some help here.

Thanks!

**63falcondude** · 12-13-2017, 08:05 PM

**td3201** · 12-13-2017, 10:44 PM

Thank you! Here was my final formula:

Please Login or Register  to view this content.

**td3201** · 12-13-2017, 11:19 PM

Actually, one more requirement. How do I get the list sorted alphabetically?

Please Login or Register  to view this content.

**FlameRetired** · 12-14-2017, 12:38 AM

I couldn't adapt your formula to return unique alphabetically. I came up with my own array entered formula.

	A	B	C	D	E	F
1	Earth	Vince		Earth
2	Mercury	Paul			Bob	In E2: {=IFERROR(INDEX($B$1:$B$20,MATCH(SMALL(IF($A$1:$A$20=$D$1,COUNTIF($B$1:$B$20,"<="&$B$1:$B$20)),ROWS($2:2)),COUNTIF($B$1:$B$20,"<="&$B$1:$B$20),0)),"")}
3	Pluto	Joe			Sandra
4	Jupiter	Joe			Vince
5	Saturn	John
6	Saturn	Elsie
7	Mars	Sandra
8	Jupiter	Vince
9	Earth	Bob
10	Mercury	Allen
11	Pluto	Alice
12	Earth	Sandra
13	Saturn	Sandra
14	Jupiter	JoAnne
15	Mercury	Bob
16	Mercury	Elsie
17	Venus	Linda
18	Jupiter	Mike
19	Pluto	Alice
20	Uranus	Susan

Re: dynamic list of unique values