Hi -
When I try your formula in column A [the header is No - so formula
starts in A2 then I get 0 as the result for A2. And it still isn't
showing consecutive numbers in descending rows. Am I doing something
wrong?

Richard


Yes it is possible, and not to difficult.
Put this in the first column: =SUBTOTAL(3,$A$2:A2) and copy down

Hope it helped
Ola Sandström


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=390153