Hello,
I need your expertise. I have few tabs with the similar data, where (a) is
below scope. I want to order all the variances above the scope (a) in
consecutive numbers by ignoring the blanks and below scope items. I am using
this formula but it doesn't work because it is counting a's.
=IF((ABS(C6)250)+ABS(E6)10%,COUNT($C$6:C6)&"","{ a}")

In addition, I want to use the next available number in the following tab,
so if the last item in sheet1 is 250, the next item in sheet2 would be 251.
Is this possible?

Thanks in advance,

a scope <2 & .25%
2006 2005 Change %
A B C D E
10 8 2 0.25 {a}
15 6 9 1.5 2
8 9 -1 -0.111111111 {a}
9 10 -1 -0.1 {a}