ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Return one instance using formula or filter (https://www.excelbanter.com/excel-discussion-misc-queries/44637-return-one-instance-using-formula-filter.html)

Pat

Return one instance using formula or filter
 
Is it possible to filter based on the following example:

colA

Acalypha
Acanthocalycium
Acantholimon
Acanthopanax
Acanthus
Acca
Acer
Acer
Acer
Acer
Acer
Aceras
Aceriphyllum
Achillea
Achillea
Achimenes

result after filtering;

Acalypha
Acanthocalycium
Acantholimon
Acanthopanax
Acanthus
Acca
Acer
Aceras
Aceriphyllum
Achillea
Achimenes


Thankyou if you can help.
Pat



bj

check advanced filter unique values in help

"Pat" wrote:

Is it possible to filter based on the following example:

colA

Acalypha
Acanthocalycium
Acantholimon
Acanthopanax
Acanthus
Acca
Acer
Acer
Acer
Acer
Acer
Aceras
Aceriphyllum
Achillea
Achillea
Achimenes

result after filtering;

Acalypha
Acanthocalycium
Acantholimon
Acanthopanax
Acanthus
Acca
Acer
Aceras
Aceriphyllum
Achillea
Achimenes


Thankyou if you can help.
Pat





All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com