Forum Discussion
Solved
Advanced formula to show number movement
Hi, I am looking for a formula to represent the difference between digit movement, the lowest difference would be 0 and the highest 5 the result would be taken from 2 columns eg. A B 7 16 =...
- You may try this formula:
=MIN(ABS(RIGHT(A2)-RIGHT(B2)),
RIGHT(A2)+10-RIGHT(B2),
RIGHT(B2)+10-RIGHT(A2),
5)
I don't quite understand but I pulled together the attached file demo which may point you in the right direction?
Hi Wyn,
Thanks for your replay I have attached an example sheet to show what result I am looking for