Spreadsheet: 120092d1314973250-excel-filtering-values-and-generating-an-average-result-forum
Sheet: Sheet1

 |  |  | Step 1 Select Values |  |  |  |  |  | Step 2 Add values together and | Step 3
 |  |  | to be averaged |  |  |  |  |  | divide by number of captured values | Enter a formula to be able to
 |  |  | Criteria start selecting when |  |  |  |  |  |  | do this in one step
 |  |  | difference <3% between values
 |  |  | Stop selcting when value drops
 |  |  | below 86% of the peak value
 |  |  | % Change |  |  | 0.03 |  |  | 2953.066666666667
 | 0 | 343
 | 10 | 492 | 0.3028455284552846 | 0 |  | <-formula | 0
 | 20 | 665 | 0.2601503759398496 | 0 |  |  | 0
 | 30 | 856 | 0.2231308411214953 | 0 |  |  | 0
 | 40 | 1056 | 0.1893939393939394 | 0 |  |  | 0
 | 50 | 1265 | 0.1652173913043478 | 0 |  |  | 0
 | 60 | 1477 | 0.1435341909275558 | 0 |  |  | 0
 | 70 | 1686 | 0.1239620403321471 | 0 |  |  | 0
 | 80 | 1889 | 0.1074642668078348 | 0 |  |  | 0
 | 90 | 2078 | 0.09095283926852743 | 0 |  |  | 0
 | 100 | 2248 | 0.07562277580071175 | 0 |  |  | 0
 | 110 | 2400 | 0.06333333333333334 | 0 |  |  | 0
 | 120 | 2534 | 0.05288082083662194 | 0 |  |  | 0
 | 130 | 2651 | 0.04413428894756696 | 0 |  |  | 0
 | 140 | 2750 | 0.036 | 0 |  |  | 0
 | 150 | 2827 | 0.02723735408560311 | 2827 | Values drop <3% between |  | 1
 | 160 | 2884 | 0.01976421636615812 | 2884 |  |  | 1
 | 170 | 2925 | 0.01401709401709402 | 2925 |  |  | 1
 | 180 | 2955 | 0.01015228426395939 | 2955 |  |  | 1
 | 190 | 2978 | 0.007723304231027535 | 2978 |  |  | 1
 | 200 | 2994 | 0.005344021376085505 | 2994 |  |  | 1
 | 210 | 3006 | 0.003992015968063872 | 3006 |  |  | 1
 | 220 | 3012 | 0.00199203187250996 | 3012 |  |  | 1
 | 230 | 3013 | 0.0003318951211417192 | 3013 |  |  | 1
 | 240 | 3011 | -0.0006642311524410495 | 3011 |  |  | 1
 | 250 | 3006 | -0.00166333998669328 | 3006 |  |  | 1
 | 260 | 2998 | -0.00266844563042028 | 2998 |  |  | 1
 | 270 | 2987 | -0.003682624707063944 | 2987 |  |  | 1
 | 280 | 2974 | -0.004371217215870881 | 2974 |  |  | 1
 | 290 | 2960 | -0.00472972972972973 | 2960 |  |  | 1
 | 300 | 2946 | -0.004752206381534283 | 2946 |  |  | 1
 | 310 | 2933 | -0.004432321854756222 | 2933 |  |  | 1
 | 320 | 2920 | -0.004452054794520548 | 2920 |  |  | 1
 | 330 | 2907 | -0.004471964224286206 | 2907 |  |  | 1
 | 340 | 2893 | -0.004839267196681645 | 2893 |  |  | 1
 | 350 | 2878 | -0.005211952744961779 | 2878 |  |  | 1
 | 360 | 2862 | -0.005590496156533892 | 2862 |  |  | 1
 | 370 | 2846 | -0.005621925509486999 | 2846 |  |  | 1
 | 380 | 2831 | -0.005298481102084069 | 2831 |  |  | 1
 | 390 | 2818 | -0.00461320085166785 | 2818 |  |  | 1
 | 400 | 2807 | -0.003918774492340577 | 2807 |  |  | 1
 | 410 | 2799 | -0.00285816362986781 | 2799 |  |  | 1
 | 420 | 2793 | -0.002148227712137487 | 2793 |  |  | 1
 | 430 | 2791 | -0.0007165890361877463 | 2791 |  |  | 1
 | 440 | 2791 | 0 | 2791 |  |  | 1
 | 450 | 2796 | 0.00178826895565093 | 2796 |  |  | 1
 | 460 | 2804 | 0.002853067047075606 | 2804 |  |  | 1
 | 470 | 2814 | 0.00355366027007818 | 2814 |  |  | 1
 | 480 | 2825 | 0.003893805309734513 | 2825 |  |  | 1
 | 490 | 2837 | 0.004229820232640112 | 2837 |  |  | 1
 | 500 | 2849 | 0.004212004212004212 | 2849 |  |  | 1
 | 510 | 2862 | 0.004542278127183787 | 2862 |  |  | 1
 | 520 | 2874 | 0.004175365344467641 | 2874 |  |  | 1
 | 530 | 2887 | 0.004502944232767579 | 2887 |  |  | 1
 | 540 | 2898 | 0.003795721187025535 | 2898 |  |  | 1
 | 550 | 2908 | 0.00343878954607978 | 2908 |  |  | 1
 | 560 | 2912 | 0.001373626373626374 | 2912 |  |  | 1
 | 570 | 2903 | -0.003100241129865656 | 2903 |  |  | 1
 | 580 | 2870 | -0.01149825783972125 | 2870 |  |  | 1
 | 590 | 2804 | -0.02353780313837375 | 2804 |  |  | 1
 | 600 | 2700 | -0.03851851851851852 | 2700 | Values drop to below 86% |  | 0
 | 610 | 2564 | -0.0530421216848674 | 2564 | of peak value 3013 |  | 0
 | 620 | 2400 | -0.06833333333333333 | 2400 |  |  | 0
 | 630 | 2215 | -0.0835214446952596 | 2215 |  |  | 0
 | 640 | 2018 | -0.09762140733399405 | 2018 |  |  | 0
 | 650 | 1812 | -0.1136865342163355 | 1812 |  |  | 0
 | 660 | 1598 | -0.1339173967459324 | 1598 |  |  | 0
 | 670 | 1381 | -0.1571325126719768 | 1381 |  |  | 0
 | 680 | 1163 | -0.1874462596732588 | 1163 |  |  | 0
 | 690 | 949 | -0.2255005268703899 | 949 |  |  | 0
 | 700 | 747 | -0.2704149933065595 | 747 |  |  | 0
 | 710 | 566 | -0.3197879858657244 | 566 |  |  | 0
 | 720 | 410 | -0.3804878048780488 | 410 |  |  | 0
 | 730 | 279 | -0.4695340501792115 | 279 |  |  | 0
 | 740 | 329 | 0.1519756838905775 | 0 |  |  | 0
 | 741 | 0 |  | 0 |  |  | 0