I am trying to create a formula to check that a list of numbers is ascending. For example, over a number of years, I might record the number of, say, letters I post. I want a formula to check that I am sending increasing numbers every year, returning a value of YES or NO. I have tried an IF formula but am told I have too many formulae (Excel 2003).
Is there a way around this problem?
Bookmarks