| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
selective averaging
I have a large data set that has a particular column containing identifiers.
Here is an example: RP11-148D23 RP11-148D23 RP11-148F17 RP11-148F17 RP11-148F17 RP11-148F17 RP11-148G20 RP11-148G20 RP11-148G7 RP11-148G7 As you can see, most of the entries in my sheet are duplicates, but there are several that are repeats of 4, 6 or 8. Each identifier has a particular data value assiciated with it. I would like to average across each identifier, averaging the associated data, but merely pasting down a row does not handle the replicates that contain more than 2 or the same kind. Is there a way to do this conveniently? My spreadsheet contains 13000 rows. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging function | Excel Discussion (Misc queries) | |||
| averaging from one selected cell to another | Excel Discussion (Misc queries) | |||
| Averaging the last 5 entries in a row | Excel Discussion (Misc queries) | |||
| 2 part question on averaging | Excel Discussion (Misc queries) | |||
| Averaging cells which contain #DIV/0! | Excel Worksheet Functions | |||
Threaded Mode
