Grading list of unique values

**fidelski** · 04-20-2013, 07:43 AM

Hello

Can anyone help me with this exercise?
I have a list of customers and their sales where there is also a representative.
From that list, I would like to filter out all the different representatives.

Topping the list I posted the different values to be displayed. This I have now typed but if the list contains many records it would be too much work to complete.

Hopefully someone can help me.

greet

Céderic

**AZ-XL** · 04-20-2013, 08:10 AM

=IFERROR(INDEX(Table1[Vertegw.],MATCH(SMALL(IF(Table1[Helper]=1,ROW(Table1[Helper])-1,""),ROW()-1),IF(Table1[Helper]=1,ROW(Table1[Helper])-1,""),0)),"") CSE

I used helper column for that and inserted into table

**martindwilson** · 04-20-2013, 08:17 AM

here is one way

**Kevin UK** · 04-20-2013, 09:35 AM

Hi fidelski

Try the following, in D3 and copy down:

Formula:

Please Login or Register  to view this content.

Grading list of unique values

LinkBack

Thread Tools

Rate This Thread

Display