View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joecrabtree joecrabtree is offline
external usenet poster
 
Posts: 111
Default 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