This is the problem. I have a formula that counts the number of draws that a 3 digit number has missed since it's been drawn. I am getting a negative number for the count. I'm not sure if it's because the sheet I'm referenced too has many dates the same or if it's because the dates are in ascending order. The formula works great on other worksheets with dates in descending order. The data on the sheet "MIRRORSMATESTOTALS" is created by a macro with data from another sheet. Is there any way the formula can be altered? Thanks for any suggestions. I have posted both sheets.
Carbob
Carbob
DOUBLESMIRRORSTOTALS MASTER.xls | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | DATE | DRAW | MATE | MIRROR | ||
2 | 01/01/03 | 147 | 692 | |||
3 | 01/01/03 | 559 | 995 | 004 | ||
4 | 01/01/03 | 741 | 296 | |||
5 | 01/01/03 | 148 | 693 | |||
6 | 01/01/03 | 706 | 251 | |||
7 | 01/01/03 | 966 | 699 | 411 | ||
MIRRORSMATESTOTALS |