Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Unique Entries (Excel '97)

    I have a large spreadsheet that contains one column of data that consists of Part Numbers. There can be many entries for a single Part Number. Say, for example, that the part numbers are in Column A. I would like a list of the unique parts in Column B and the number of entries for the corresponding part Number in Column C.

    I realize that I can Sort the part numbers to group them together, but I am hoping that there is an automated process for extracting the data I need.

    Any comments or suggestions would be appreciated.

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Unique Entries (Excel '97)

    Use the Advanced filter. You can copy to new location and tell excel to copy over only unique values only.

    Steve

  3. #3
    3 Star Lounger Jim Cone's Avatar
    Join Date
    Feb 2002
    Location
    Portland, Oregon, USA
    Posts
    238
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: Unique Entries (Excel '97)

    Another way is to...

    Add a title directly above the list of numbers
    Select the title and the list
    Goto Data | Pivot Table
    On the layout view, drag the title to the row field and also drag the title to the data field.
    OK and Finish your way out of the pivot table.
    (takes about 8 seconds to accomplish)

    You wil have a list of all the part numbers with the count for each.
    This list can be copied and pasted where you want.

    Jim Cone
    San Francisco, CA

  4. #4
    Lounger
    Join Date
    Jan 2001
    Location
    Easley, South Carolina, USA
    Posts
    45
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Unique Entries (Excel '97)

    Thanks. That did exactly what I needed.

Posting Permissions

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