My workbook currently has 10 tabs in chronological order...day 1...day 2...etc.
On the last sheet I have a nested-if formula that begins on day 1 to see if a value changed, if so - that is the acceptance date. If not, then it looks onto day 2, and so on.
This is about to go from 10 tabs to many many more and too many for a nested-if. Is there an alternative to a nested-if in this case?
On the last sheet I have a nested-if formula that begins on day 1 to see if a value changed, if so - that is the acceptance date. If not, then it looks onto day 2, and so on.
This is about to go from 10 tabs to many many more and too many for a nested-if. Is there an alternative to a nested-if in this case?
