|Posted: June 29, 2011, 1:14 am - IP Logged|
I wanted to know what formula can be used to count the difference of cells between two numbers repeated numbers in different rows?
I would like to know the how far apart each number from the top is from it's duplicate. If you count from left to right starting with the top number. The 10 is 5 columns to the right apart from the bottom 10 so my result is 5
Then basically do the same thing for every number, but you have to start the count from the number on top and whichever number you use you go from left to right staring at that number.
14 is 2 columns apart to the right
19 is 0 columns apart
2 is 3 columns apart>>>the two is two columns to the right apart and then one column at the beginning.
5 is 3 columns apart>>>one columns to the right apart and then two column at the beginning.
32 is 5 columns apart>> there is no more space to the right so you start the count from the beginning
This was the best way I can explain it....can this be made in to a formula?
"It's evolve or die, really, you have to evolve, you have to move on otherwise it just becomes stagnant."