Repost of Unique entries

[Peter99]

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

 

[Jack in the UK]

see post http://www.mrexcel.com/board/viewtopic.php?topic=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!