Counting average number of unique outputs

sultanijaz

New Member
Joined
Nov 11, 2015
Messages
2
Hi all,

Trying to figure out how to do this, even a long winded way if anyone has any ideas.
CompanySpend Category
ABCGas
ABCElectricity
DEFWater
ABCElectricity

<colgroup><col><col></colgroup><tbody>
</tbody>

I have something like the table above and the end goal is to calculate the average number of spend categories per company. Some companies will have more than one of the same spend categories.

Any help would be appreciated.

Thanks
Sultan
 

Some videos you may like

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

SpillerBD

Well-known Member
Joined
Jul 2, 2014
Messages
2,706
AVERAGE of COUNTS is not a built in feature of Pivot Tables. You will have to go to PowerPivot/DAX formulas to feed a Pivot Table via data model.
You could also go old-school with an array-formula...
 

Watch MrExcel Video

Forum statistics

Threads
1,099,510
Messages
5,469,042
Members
406,631
Latest member
hotspot1972

This Week's Hot Topics

Top