Hi all
Basically I have a large column of data (15000 values) and would like to out how many pairs have a difference of less than 10.
ie A
1 45
2 50 In this case there are 2 instances, (A1 and A2), and (A2 and A3)
3 42
4 25
5 90
Been playing around with the =COUNTIF code but I just can't manage to do it
Any help would be appreciated!
Bookmarks