| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can I average data from a repeating list into a unique list?
Use a pivot table. Select any cell in your table, then go to Data-Pivot
table and click on Finish. In the diagrm that comes up, drag the Names to the row area and the data to the data area. Right click on the data field name and choose average "Hicoda" wrote: I have a list of twenty five names. This list contains data from 1 month. Each name has multipule occurances. I need to create a list of unique names with the average of each individules data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Unique drop down list | Excel Worksheet Functions | |||
| Data Validation and Blanks in List | Excel Worksheet Functions | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How do I create a list in excel that contains external data? | Excel Discussion (Misc queries) | |||
Linear Mode
