Autofill Questio
 

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
==================

If the formula starts in row 1, use:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
==================
.

Thanx Jason, seems to work great!!!!

Dennis
====================

In article , "Jason Morin"
wrote:
If the formula starts in row 1, use:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
==================
.

This also works:

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

Regards,

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


"Jason Morin" wrote in message
...
If the formula starts in row 1, use:

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

HTH
Jason
Atlanta, GA

-----Original Message-----
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
==================
.