| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Worksheet function?
I have file with several thousand rows, and would like to average one of the
columns based on a second rows groupings. What would be the best way to do that? Thank you. Example: (I would like to average all the yellows and all the blues and all the greens, etc.) Column A Column B Yellow 1.34 Yellow 8.2 Yellow 6.11 Blue 7.78 Blue 9.27 Blue 15.7 Green 3.5 Green 1.97 Green 6.55 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get ONLY new info from 1 Worksheet to another automatical | Excel Worksheet Functions | |||
| CELL Function and Worksheet Name in a Cell | Excel Worksheet Functions | |||
| Average Function (include Blank Cells and Zeros) | Excel Discussion (Misc queries) | |||
| Passing a WorkSheet from a Function??? | Excel Worksheet Functions | |||
| numerical integration | Excel Discussion (Misc queries) | |||
Threaded Mode
