S
San
Hi all,
I have a table as follows
Col A Col B Col C
Consumption Average Kcal Energy %
0.62 4824 8.02
0.64 4773 8.15
0.71 4137 8.23
0.685 4366 8.26
0.67 4398 8.34
0.723 4026 8.45
0.701 4111 8.40
0.69 4216 8.50
---- ---- ----
--- ---- ----
I would like to find the following
1. Count of Col A figures for specified ranges, for. e.g. (0.60-0.64); (0.64-0.67), (0.67-0.70), (0.70-0.73)
2.Average of Col B figures against the above-mentioned specified ranges of Col A
3. Minimum and Maximum of Col C figures against the above-mentioned specified ranges of Col A
Thanks in advance.
San
I have a table as follows
Col A Col B Col C
Consumption Average Kcal Energy %
0.62 4824 8.02
0.64 4773 8.15
0.71 4137 8.23
0.685 4366 8.26
0.67 4398 8.34
0.723 4026 8.45
0.701 4111 8.40
0.69 4216 8.50
---- ---- ----
--- ---- ----
I would like to find the following
1. Count of Col A figures for specified ranges, for. e.g. (0.60-0.64); (0.64-0.67), (0.67-0.70), (0.70-0.73)
2.Average of Col B figures against the above-mentioned specified ranges of Col A
3. Minimum and Maximum of Col C figures against the above-mentioned specified ranges of Col A
Thanks in advance.
San