Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Averaging a dynamic range...Help ???
I've got basically three columns. ID, description, and numerical value
I would like to get an average of everything with identical ID an Description, then put that average in the fourth column, but only o the first instance of the ID and Description. The columns can be sorte first if it's easier. I don't know how many of each there are. example: ID Description Value Average 1 a 13 13 1 b 10 15 1 b 20 2 a 20 22 2 a 24 3 a 20 24 3 a 22 3 a 26 3 a 28 3 b 27 27 I've never written my own macro, and it's been forever since i eve modified someone else's. Even just a headstart would be greatl appreciated. Ric -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Averaging a dynamic range...Help ???
Hi
try the following array formula in cell D2 (entered with CTRL+SHIFT+ENTER): =IF(MATCH(1,($A$1:$A2=A2)*($B$1:B2=B2),0)=ROW(),AV ERAGE(IF (($A$2:$A$100=A2)*($B$2:$B$100=B2),$C$2:$C$100))) and copy this down -----Original Message----- I've got basically three columns. ID, description, and numerical value. I would like to get an average of everything with identical ID and Description, then put that average in the fourth column, but only of the first instance of the ID and Description. The columns can be sorted first if it's easier. I don't know how many of each there are. example: ID Description Value Average 1 a 13 13 1 b 10 15 1 b 20 2 a 20 22 2 a 24 3 a 20 24 3 a 22 3 a 26 3 a 28 3 b 27 27 I've never written my own macro, and it's been forever since i even modified someone else's. Even just a headstart would be greatly appreciated. Rich --- Message posted from http://www.ExcelForum.com/ . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
averaging a range | Excel Worksheet Functions | |||
Averaging times that are not in a range | Excel Worksheet Functions | |||
Averaging data across a date range | Excel Worksheet Functions | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Changing the range of several averaging functions | Excel Discussion (Misc queries) |