Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Pat
 
Posts: n/a
Default 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


  #2   Report Post  
bj
 
Posts: n/a
Default

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula ? Return value from rightmost non-blank cell in a row of tgdavis Excel Worksheet Functions 8 April 27th 06 01:00 PM
Return Single Instance of Numeric Values from a Column Sam via OfficeKB.com Excel Worksheet Functions 4 August 26th 05 03:10 AM
Excel - return a picture or range rows as the result of a formula juststarting Excel Worksheet Functions 1 July 4th 05 12:59 AM
HOW CAN I MAKE A FORMULA RETURN A ZERO Jim Lowe Excel Discussion (Misc queries) 3 May 26th 05 08:32 PM
Creating a check mark box MarthaSue Setting up and Configuration of Excel 18 April 28th 05 12:31 AM


All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"