Get Avg based on unique name

[rdirvngjr]

I have large spreadsheets with 4 columns (ServerName, Date, Time, %CPU) and anywhere from 450,000 to 600,000 rows of data. I added a 5th column called "AvgCPU'. I want to be able to avg the %CPU numbers for each uniquely named server. Is there a way to do this?
The number of rows for server data varies; could be 364 rows or as little as 10-12 rows.
Right now I manually scoll down thru the rows of data to highlight the range of %CPU numbers for each host and then enter a formula in the first row of each server's data to avg the range of numbers for that particular server. This works, giving me an Avg CPU number for each server, but is extremely time consuming...and prone to errors if you don't highlight the correct range of %CPU numbers.
Thoughts on how to automate?
Thanks....
Dean

 

[Andrew Poulsom]

Have you tried a pivot table?

 

[mole999]

how many servers ?

 

[rdirvngjr]

Yes, I've tried Pivot Tables but can't get the average for each server. Pivot table shows all the data entries.

 

[rdirvngjr]

the number of servers varies between a dozen to over 1500! Usually in the 1000-1400 range.

 

[Andrew Poulsom]

Yes, I've tried Pivot Tables but can't get the average for each server. Pivot table shows all the data entries.

Just add ServerName as the Row field and Average of %CPU as the Data field (don't add the Date and Time).