I have a problem where A is a range counted between 1101 and 1300, and I need the count between the 2 values. For example A1=1159, A2=1236 then B2=77. My problem is when A2=1236, A3=1108. I can't figure out the formula to make B3=72. Any help?
I have a problem where A is a range counted between 1101 and 1300, and I need the count between the 2 values. For example A1=1159, A2=1236 then B2=77. My problem is when A2=1236, A3=1108. I can't figure out the formula to make B3=72. Any help?
Welcome to the forum.
In B2 and down,
=IF(A2>=A1, A2-A1, 1300-1101+1-A1+A2)
Or,
=MOD(A2-A1, 1300-1101+1)
Last edited by shg; 06-04-2011 at 01:51 PM.
Entia non sunt multiplicanda sine necessitate
Thanks, this has worked pefectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks