![]() |
Need faster/shorter formula
Is there a way to add the numbers in row 2 that have the same date so that if
the result is Equal to, OR, minus 1 to 3 before, OR, plus 1 to 3 over (say 30), then diplay the result, otherwise display nothing? Formula needs to be in row 3 and if the date are different, as in B1, then the calculation would start over with the new date in the next column. Desired results are shown in row 3 My attempts have resulted in formula that is too long. A B C D 1 Date 8/29/02 11/6/05 11/6/05 2 Draft 16 20 7 3 New 16 27 Thank you Luke |
All times are GMT +1. The time now is 05:46 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com