Sorting data?
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Sorting data?

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I'm working on a pilot logbook in Excel.

    Right now I have some columns with data that I would like to manipulate.

    For example Column C contains registrations.

    What I would like to do is go through the column, extracting unique registrations, and putting them in their own column.

    I would then count the number of flights per plane.

    i.e.
    Column C contains the following: FILQ, FQHT, FQHT, FIMM, FILQ

    I want to create a column with only: FILQ, FIMM, FQHT

    Is there a way to do this? Preferably as a forumla and not a macro.

    Thanks

  2. #2
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,605
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try Advanced Filter. Go to Data, Filter, Advanced Filter. Choose "Unique records only", and "Copy to" (the last to move to a new column).

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Sweet, thanks, that definitely simplifies things.


User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com