| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Average Duplicates in Excel
Hi,
I am trying to write formula that calculates the averages if the identifiers are duplicated. I mean, in the data I am working with the first column (A) is IDs and other columns (B-$) contain the actual data. I want to find the duplicated IDs in column A and then average the corresponding data in column b, then c, ....etc. Any help please? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 7.0 - removing duplicates | Excel Worksheet Functions | |||
| Need Assistance: Average/Remove Duplicates | Excel Discussion (Misc queries) | |||
| Deleting duplicates in Excel | Excel Worksheet Functions | |||
| Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
| Finding duplicates in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
