Unique record extract

[makinmomb]

I have seen this by TONY VALKO

Please Login or Register  to view this content.

This is unique count

I am looking for unique extract , see file attached

it must be somewhere asked by someone else , did not find

[makinmomb]

I also know data menu has unique extract toolbar too ,
but I need a formula for linking to a small automated file

[martindwilson]

one way
leave c1 blank then in c2 put
=IFERROR(INDEX($A$1:$A$12,MATCH(0,COUNTIF($C$1:C1,$A$1:$A$12),0)),"")
array entered with ctrl+shift+enter
fill down

[makinmomb]

Okay i will take that , leaving thread open for non array

[AlKey]

Or you can use this formula without Ctrl+Shift+Enter
in C2 and copy down.

=IFERROR(INDEX($A$1:$A$12,MATCH(0,INDEX(COUNTIF($C$1:C1,$A$1:$A$12),,),)),"")

[Vikas_Gautam]

Hi Makin...

Got the solution...

Check the attachment....


Don't forget to click *

[MarvinP]

Hi makinmomb,

I like and use Pivot Tables for most of these kinds of problems. Instead of removing dups you can do a very quick pivot table to get what you want. See the attached.

[makinmomb]

Marvin thanks for the pivot table trick , will use it somewhere

Vikas your formula is array , does not work with simple enter

ALKEY i tried yours does not give result

[Vikas_Gautam]

Okay man..
Thanks, for replay..

[AlKey]

Marvin thanks for the pivot table trick , will use it somewhere

Vikas your formula is array , does not work with simple enter

ALKEY i tried yours does not give result

Sorry, forgot that you using Excel 2003

Try this one now

=IF(ISERROR(INDEX($A$1:$A$12,MATCH(,INDEX(COUNTIF($C$1:C1,$A$1:$A$12),,),))),"",INDEX($A$1:$A$12,MATCH(,INDEX(COUNTIF($C$1:C1,$A$1:$A$12),,),)))

[makinmomb]

Yes ALKEY you have sorted ,
you will be glad to know I have created a folder by
the name of ALKEY where I have several answers
of yours that i use in daily life usage , cheers

[AlKey]

You're welcome and thank you for the feedback!