Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Repost of Unique entries

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

    Default

    My question is related to Excel 97 and is basically twofold.

    1) I want to count the number of unique occurences in a list. In the example below the count of both Column A & B would be 3.


    Column A Column B

    Item type Department

    A Accounts

    A Sales

    C Sales

    B Sales

    B Accounts

    B Admin

    C Admin

    A Sales

    2) Using the same example data, I want to count the number of departments that use the individual Item types.

    Required result being; Type A = 2 (Accounts & Sales)
    Type B = 3 (Accounts, Sales & Admin)
    Type C = 2 (Admin & Sales)

    I have given column B an Alpha entry as this is how I would like it idealy to be, but the departments could be referenced numerically if this would assist.

    many thanks in anticipation of a solution



  2. #2
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    see post http://www.mrexcel.com/board/viewtop...5382&forum=2&2

    Pete i have bothered to reply and this will work im sure so whats up you have not responded, if im incorrect or you need help why not ask me ill do all i can, lokk at the number of post assigned to my name.

    Sorry to kill this feed but one is enough.. two will cause comfusion and get us all no where fast

    remember im trying to hlep not anoy!


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

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
  •