Repost of Unique entries

Peter99 · Apr 16th, 2002, 05:20 PM

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 · Apr 16th, 2002, 05:24 PM

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!

Apr 16th, 2002, 05:24 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	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"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 05:20 PM	#1
Peter99 New Member Join Date: Mar 2002 Posts: 7	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