Autofill Questio

D

Dennis

Using =COUNTIF(B:B,">150") I would like to autofill down with the handle and
have the 150 increment up eg: 151 152 153 while the B:B stays constant.

TIA, Dennis
==================
 
J

Jason Morin

If the formula starts in row 1, use:

=COUNTIF(B:B,">"&150+ROW()-1)

HTH
Jason
Atlanta, GA
 
R

RagDyeR

This also works:

=COUNTIF(B:B,">"&ROW(A150))
--

Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit !
--------------------------------------------------------------------


If the formula starts in row 1, use:

=COUNTIF(B:B,">"&150+ROW()-1)

HTH
Jason
Atlanta, GA
 
Top