Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Average Unique Nadine Excel Worksheet Functions 7 April 28th 10 09:47 PM
Filer for unique records and return all column data for unique rec bseeley Excel Discussion (Misc queries) 1 September 12th 09 12:17 AM
How can I average data from a repeating list into a unique list? Bob Phillips Excel Worksheet Functions 0 March 3rd 06 06:47 PM
How can I average data from a repeating list into a unique list? Duke Carey Excel Worksheet Functions 0 March 3rd 06 06:38 PM
Excel to PDF w/ Data Tags Dorian C. Chalom Excel Discussion (Misc queries) 0 October 18th 05 09:13 PM


All times are GMT +1. The time now is 03:38 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"