Can't filter "Unique" records from Filtered range

Apologies if this has been answered already, but couldn't find it when I searched.

Sheet 2 has a five column database of records, with Project Numbers in Col A, and Client Names in Col C.

Following Code filters the database to show only the records matching whichever Client is selected in D3 of another sheet. Works perfectly at that point.

I then need to extract the "unique" Project Numbers from the filtered Col A, and copy the list to somewhere else, so I end up with a list of the Projects relating to the Client selected.

Please Login or Register  to view this content.

Any suggestions, pointers or alternative solutions welcome as ever

Ochimus

How about

Please Login or Register  to view this content.

CK,

Many thanks for prompt response.

If the question had been "complex" I would (as I usually do) upload a sample workbook.

But in this case it was the principle I needed, so the Code was perfectly adequate, as you demonstrated by outlining various options, for which I am extremely grateful.

Ochimus