Count unique values in excel

Mstest / Awrdacpi
October 11, 2012 at 02:21:44
Specs: Microsoft Windows XP Professional, 2 GHz / 958 MB
Hi,

I am having a hard time getting the unique values in a certain from which has more than one criteria. I have a summary wherein on the first column it shows the different business unit then the next columns would be the month/year. From my raw data I want to count the unique values of the supplier for a certain month and for the assigned business unit.


Business Unit
Jan/2011
Feb/2011
Mar/2011

Craftsmen
7
6
6

Electronics
5
5
6

Industry
3
3
3

Industrial
17
17
17

Transportation
7
9
7

Total	
92
93
93

For example: Business Unit Craftsmen, I want to count how many unique supplier it has for the month of January.

Thanks. :)


See More: Count unique values in excel

Report •


#1
October 11, 2012 at 09:51:19
I don't understand the layout of your example data.

You said "first column it shows the different business unit then the next columns would be the month/year" but you only posted 1 column of data.

I don't see any relationship between Business Unit Craftsmen and the month of January.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question