Hello All,
I am attempting to introduce a little bit of filtering into some data I have.
I have a column of numbers with values associated with them in the neighbouring column, and I would like to only select those values that have a difference great than x from the previous value. For example: If I have a set of numbers as below, with x=0.02:
1.301
1.322
1.342
1.362
1.380
1.398
1.415
1.431
1.447
1.462
1.477
1.491
1.505
1.519
1.531
1.544
1.556
1.568
1.580
1.591
1.602
1.613
1.623
1.633
1.643
1.653
1.663
1.672
1.681
1.690
1.699
1.708
1.716
1.724
1.732
1.740
1.748
1.756
1.763
1.771
1.778
1.785
1.792
1.799
1.806
1.813
1.820
1.826
1.833

I would like excel to produce the numbers below with the corresponding values from the neighbouring column to go with them:
1.301
1.322
1.342
1.380
1.415
1.431
1.462
1.491
1.519
1.544
1.568
1.591
1.613
1.633
1.663
1.690
1.716
1.740
1.763
1.785
1.806
1.833

I hope this makes sense. Any help would be gratefully received!