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.
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.