Advanced filters

[KasperSSI]

Hi,

I have a data set of account numbers and product lines, e.g:

Account Product
100 1
100 1
100 2
200 2
200 3
200 3

Is it possible to set a filter to show only uniques. What I would like to show:

Account Product
100 1
100 2
200 2
200 3

I know this can be done very easily in a pivot. However I would like to use it in my main table.

Thank you in advance.

Br,

Kasper

 

[Fluff]

You could use an advanced filter like this

+Fluff 1.xlsm
	A	B	C	D
1	Acc	Prod
2	100	1		TRUE
4	100	2
5	200	2
6	200	3
Master

Cell Formulas
Range	Formula
D2	D2	=COUNTIFS(A$2:A2,A2,B$2:B2,B2)=1

Set the criteria range to D1:D2