Difference between consecutive number
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!
Welcome to the forum.
Assuming you mean adjacent pairs,
=SUMPRODUCT(--(ABS(A1:A4-A2:A5)<10))
Entia non sunt multiplicanda sine necessitate
do you mean compare pairs in columns A and B?
is there a way you can attach a simplified spreadsheet with some dummy data?
If I helped, Don't forget to add to my reputation (click on the little scale)
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
Brilliant, thanks! now i can stop banging my head against a wall
hi shg,
can you briefly explain the combination of these "--" with SUMPRODUCT. I often use a sumproduct(--(range1=criteria),(range2=criteria)). BUT I never understood the implication of this "--". Thanks for enlightening me on this subject.
Have a good read through this article: Sumproduct
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks