Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Unique Data ID tags help (average)
To all,
I have a load of data for different locations eg: B4 at1000°C(1) = 98 B4 at1000°C(2) = 88 B4 at1000°C(3)= 88 C4 at777°C(1)= 23 C4 at777°C(2)= 22 B5 at1000°C(2)= 19 What I want to be able to do is analyse the data id number i.e. C4 at777°C and then average all the data for that location, in this case ( 22 +23)/2. etc. and then give an output of C4 at777°C= 22.5 etc. I guess that I have to search through the data and create a set of unique data ids, in this case would be B4 at 1000, C4 at 777, and B5 at 1000, and then define these as variables and re search through the data to get the averages? Any Ideas. The number of locations ( data id ) can change and is not constant. Thanks in advance for your help, Regards Joseph Crabtree |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Average Unique | Excel Worksheet Functions | |||
Filer for unique records and return all column data for unique rec | Excel Discussion (Misc queries) | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
How can I average data from a repeating list into a unique list? | Excel Worksheet Functions | |||
Excel to PDF w/ Data Tags | Excel Discussion (Misc queries) |