Averaging Specific data

[deante]

I have a sheet with data containing different machine names. I want to find the average of each machine by name and input the average values into a bar chart in excel.

The data looks like this

Machine 1 5
Machine 2 4
Machine 3 6
Machine 4 3
Machine 2 5
Machine 2 6
Machine 1 5

I would like to produce a table that shows

Machine 1 5
Machine 2 5
Machine 3 6
Machine 4 3

I tried using subtotals to calculate the average but I can not make a chart. Pivot tables would not work because there are over 255 machines.

Thanks in Advance,

DeAnte

 

[xlhelp]

if your data is range1 and range 2 (machine names and values, respectively)

then in your table next to the machine name, type a formula

=SUMIF(range1,A2,range2)/COUNTIF(range1,A2) where cell A2 in your table would have name Machine 1

 

[firefytr]

Also, look up array formulas for additional criteria. And there always is pivot tables as well..

-----------
Regards,
Zack Barresse

 

[KenWright]

Pivot Tables worked fine for me, and I used over 1000 machines.

Regards
Ken...........

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission
----------------------------------------------------------------------------