Return the unique data from a list

[groundin]

I am looking to extract the different hole sizes from this list. I need it to return 311 / 222 / 156 from Column C.
Is there a way to do this?

Please Login or Register  to view this content.

[alansidman]

Read here and look at the steps to copy to a new location

http://office.microsoft.com/en-us/ex...010073943.aspx

[groundin]

That works great, but I need it to do it automatically, this page is a "data base" page that is updated from other pages. That being said, is it possible to do? If it were to return each value to its own separate cell then I can combine them using &"/"&.
Thanks

[vlady]

maybe this one.

unique.xlsx

[groundin]

Seems to work, I need to tweak it, I will post what I come up with once I get it working, Thanks for the help!

[groundin]

Ha! Thought I could figure it out, I couldn't...
Can you take a look I have your formula in column P, I want the unique values from column C returned, similar to your example. Just to note column C may have only one value, but could have as many as 10 or anywhere in between.

Unique example.xlsx

[vlady]

just slight look underlined..it should be in P1:P1 not in P2:P2

=IFERROR(INDEX($C$2:$C$11,MATCH(0,INDEX(COUNTIF($P$1:P1,$C$2:$C$11),0,0),0)),"") -array entered.

[groundin]

Perfect! Thanks!

[Teethless mama]

just slight look underlined..it should be in P1:P1 not in P2:P2

=IFERROR(INDEX($C$2:$C$11,MATCH(0,INDEX(COUNTIF($P$1:P1,$C$2:$C$11),0,0),0)),"") -array entered.

No need array entered. Normally Enter will do.

[amitkr3855]

can also use this one
array formula need ctrl+shift+enter
In D2

=IFERROR(INDEX($B$1:$B$6,MATCH(0,COUNTIF(D$1:D1,$B$1:$B$6),0)),"")