Lookup unique values

[oteixeira]

Hello to all.
I need to accomplish this task without using VBA or Filter tool.

1.On cell A2 the user will enter ONE UNIQUE value of “Customer” column
2.Beginning on cell G6 and down I need to extract ALL unique values of “Product” column based on the value chosen on A2.

Please have a look to the uploaded file “Test.xlsx”

Thanks in advance for any kind help.
Octavio

[NeedForExcel]

Here!

Put this on Cell G6 -

Please Login or Register  to view this content.

Commit using Ctrl+Shift+Enter

[LokeshKumar]

Here!

Put this on Cell G6 -

=IFERROR(INDEX($D$6:$D$21,SMALL(IF($A$2=$C$6:$C$21,ROW($C$6:$C$21)-ROW($C$6)+1),ROWS($G$6:G6))),"")

Commit using Ctrl+Shift+Enter

It is not showing unique values.....I have tried CSE

Attachment 391612

[NeedForExcel]

Oops!

Seems I missed the "Unique" Part..

[samba_ravi]

G6=IFERROR(INDEX($D$6:$D$21,MATCH(0,INDEX(($C$6:$C$21<>$A$2)+COUNTIF($G$5:$G5,$D$6:$D$21),0),0)),"")
try this and copy towards down
you can also use pivot table - see attached file

[oteixeira]

Thanks Siva
And thanks to all other too.
Octavio