# Which formula would I use to check numbers are ascending?

1. ## Which formula would I use to check numbers are ascending?

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?  Register To Reply

2. ## Re: Which formula would I use to check numbers are ascending?

Not entirely clear - a sample file might help

It might prove to be the case that something like: ``Please Login or Register  to view this content.``
would work - where A1:A4 holds your list
(a1 being first entry and A4 being last with expectation that each value should be bigger than (or equal to) the last)

Modify ranges to suit but keep as lean as possible when using SUMPRODUCT (it's not efficient) - entire column references are not permitted in XL2003  Register To Reply

3. ## Re: Which formula would I use to check numbers are ascending?

I'm not sure that solves the problem. Let me give an example.

2010 20
2009 18
2008 14
2007 13
2006 8
2005 5

Is the number constantly increasing: YES

2010 20
2009 18
2008 14
2007 15
2006 8
2005 5

Is the number constantly increasing: NO.

Therefore a sumproduct calculation will not necessarily pick up on the one year where there was a cut. If the list is 100 long for instance, then the formula does not become lean, as you suggest, in any case.  Register To Reply

4. ## Re: Which formula would I use to check numbers are ascending?

The formula provided works only I assumed years in reverse order and that values were in Col A rather than B.

All you need do is reverse the < operator to > and revise the ranges (to reflect Col B)

Where the result of the SUMPRODUCT is anything other than 0 then there is a drop at some point in proceedings.  Register To Reply

5. ## Re: Which formula would I use to check numbers are ascending?

Worked perfectly. Thank you for your help!  Register To Reply