Find automatic range

[neam]

Hi everyone
I want to intelligently calculate the average of that range by selecting the station column wherever kilometers change.

Point	Station	Offset	Elevation	Cross Section Station
305	9.67	17.478	102.039m	1	10
316	9.80	-3.148	101.528m	1
317	9.81	-5.016	101.847m	1
306	9.87	13.996	102.240m	1
322	9.88	-8.795	102.262m	1
323	9.91	-10.798	102.156m	1
320	9.92	-5.409	102.796m	1
321	9.96	-6.64	102.909m	1
312	10.02	2.451	101.650m	1
311	10.05	4.907	101.974m	1
310	10.10	5.274	102.553m	1
307	10.12	10.049	102.283m	1
308	10.13	7.144	102.126m	1
309	10.14	6.308	102.410m	1
325	10.18	-16.117	102.011m	1
324	10.23	-13.882	102.200m	0	47
301	46.15	8.529	102.155m	1
302	46.20	11.863	102.114m	1
298	46.22	4.401	102.413m	1
297	46.23	3.906	101.869m	1
296	46.31	2.787	101.573m	1
299	46.31	5.195	102.666m	1
300	46.33	5.941	102.636m	1
292	46.59	-2.705	101.492m	1
291	46.61	-4.625	102.073m	1
290	46.68	-5.085	102.636m	1
289	46.75	-6.38	102.617m	1
303	46.87	16.48	102.016m	1
288	46.91	-7.312	102.106m	1
287	46.93	-8.603	102.044m	1
283	46.96	-14.173	102.307m	1
285	46.97	-11.047	101.835m	1
284	46.98	-13.418	101.878m	1
286	46.99	-9.779	102.491m	1
281	46.99	-15.712	101.918m	1
282	46.99	-14.822	102.368m	1
280	47.14	-21.221	101.914m	1
279	47.15	-26.622	101.843m	1
304	48.62	18.268	102.049m	0	141

 

[Joe4]

Welcome to the Board!

I think maybe the reason you have not gotten any replies is because people don't quite understand your question.
Which of your columns are you trying to average?
Can you walk us through an example, based on your data sample above, and show us your expected results?

 

[neam]

Welcome to the Board!

I think maybe the reason you have not gotten any replies is because people don't quite understand your question.
Which of your columns are you trying to average?
Can you walk us through an example, based on your data sample above, and show us your expected results?

Thank you for your attention
I want to calculate the average number of numbers in the range where this condition is in place if the absolute value of the first number and the second number from the station column is between zero and two.

 

[Joe4]

Repeated from my last post:

Which of your columns are you trying to average?

Can you walk us through an example, based on your data sample above, and show us your expected results?

It still is not clear to me what are you trying to do. Remember, while you are familiar with your problem, we are not. All we know if whatever you have posted here.
You have a number of columns. Which one exactly are you trying to average?

Please walk us through an example based on the actual data you posted, showing us your expected value and explaining exactly how you got there.

Examples often do a better job of showing exactly what you are trying do to than just plain words.

 

[neam]

Repeated from my last post:

Which of your columns are you trying to average?

Can you walk us through an example, based on your data sample above, and show us your expected results?

It still is not clear to me what are you trying to do. Remember, while you are familiar with your problem, we are not. All we know if whatever you have posted here.
You have a number of columns. Which one exactly are you trying to average?

Please walk us through an example based on the actual data you posted, showing us your expected value and explaining exactly how you got there.

Examples often do a better job of showing exactly what you are trying do to than just plain words.

CivilReport1.xls
	A	B
1	Station	Formula
2	9.67	10
3	9.80
4	9.81
5	9.87
6	9.88
7	9.91
8	9.92
9	9.96
10	10.02
11	10.05
12	10.10
13	10.12
14	10.13
15	10.14
16	10.18
17	10.23	47
18	46.15
19	46.20
20	46.22
21	46.23
22	46.31
23	46.31
24	46.33
25	46.59
26	46.61
27	46.68
28	46.75
29	46.87
30	46.91
31	46.93
32	46.96
33	46.97
34	46.98
35	46.99
36	46.99
37	46.99
38	47.14
39	47.15
40	48.62	141
41	140.54
Sheet1

Cell Formulas
Range	Formula
B2	B2	=ROUND(AVERAGE(A2:A17),0)
B17	B17	=ROUND(AVERAGE(A18:A40),0)
B40	B40	=ROUND(AVERAGE(A41:A60),0)

 

[Peter_SSs]

I want to intelligently calculate the average of that range by selecting the station column wherever kilometers change.

There is no mention of kilometers in you data?

 

[neam]

There is no mention of kilometers in you data?

Column A (station) is kilometer

 

[neam]

There is no mention of kilometers in you data?

Kilometers don't matter at all. Let's assume we have a series of numbers.

 

[Peter_SSs]

Column A (station) is kilometer

That would have taken a bit of guessing!

Kilometers don't matter at all. Let's assume we have a series of numbers.

So how do we decide which ones need to be averaged?

 

[neam]

That would have taken a bit of guessing!



So how do we decide which ones need to be averaged?

As long as the absolute value of the difference between the first and second numbers, the second and third numbers, etc., is between zero and two, the average of the numbers in this range is calculated.