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