Advanced Filter

[efernandes67]

Hi,

See file in attach.

I have in column A some names and in column C a formula to check if the values in A match the formula.

I would like to create an advanced filter to copy the UNIQUE values from column A with the criteria that matches the formula in C2, to column E.

Regards,
Elio Fernandes

[martindwilson]

in columm d d2 put
=OR(LEFT(A2,2)="65",LEFT(A2,2)="66",LEFT(A2,2)="82",LEFT(A2,2)="84",LEFT(A2,2)="89")
select column A
advanced filter
make sure the list range refers to col A
set criteria range as $D$1:$D$2
click copy to another location ,select e1, check unique only then ok

[efernandes67]

Thanks Martin.