I am trying to do some analysis on my backup speeds for our Netbackup system. I can grab the output from the Netbackup GUI and pop it into a spreadsheet. Example result types are in the attached spreadsheet. For each Value SU1, SU2, and SU3 (Column E) I need to find the average, the min and the max for KB/Sec (Column C). Of course, as I fill up the spreadsheet the values SU1, SU2, and SU3 will be interspersed all over the place in Column E. I've tried some simple IF statements in combination with the AVERAGEIF, MAX, MIN, etc functions, but kind of hit roadblocks since I'm not an advanced user of Excel and all it various functions.
Some of my attempts have been:
Please Login or Register to view this content.
As well as other. Any ideas would be greatly appreciated.Please Login or Register to view this content.
Bookmarks