How would you do this? Table Question.

[linger]

Hi...

I have an excel sheet that looks something like this. (Sorry I didn't know how to paste the sheet on the textbox) I tried using the location as the column headers but I ran into problems trying to find the max, min and standard deviation. This sheet applies to only one record. If anyone is willing to help, I'll send you the files to have you take a look at it. THanks.

Yiling

Line location shape T C B TSB
1 8-15
2 2-10
3 8-29
4 15-10
5 8-2
6 ave average of line 7 to 18 for each column

7 4-5
8 4-16
9 6-5
10 6-26
11 7-11
12 7-20
13 10-16
14 11-5
15 11-26
16 13-5
17 13-16
18 ave average of line 7 to 18 for each column
19 Total Ave Ave of 6 and 18 of all columns
20 min mininum on each of 5 columns
21 max maximum on each of 5 columns
22 stdev standard deviation on each of 5 columns

 

[Yogi Anand]

Hi linger:

From the data you have presented it is not clear what you are trying to describe; and then what is that you need help with. I suggest you post your sample data using Colo's Cool utility, HTMLmaker (downloadable from MrExcel page) and then let us take it from there.