Excel 2003
Data-Filter-Advanced-select your ranges and tick "Unique records
only"


On 23 Mar, 09:26, "IgorM" wrote:
Hi

How to get distinct items from a recordset? Let's assume I have two columns
returned from a database: countries and cities.
I want to retrieve a list of unique country names.

Kind regards
IgorM