Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ================== |
#2
|
|||
|
|||
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 ================== . |
#3
|
|||
|
|||
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 ================== . |
#4
|
|||
|
|||
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 ================== . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoFill Linked Cells | Excel Discussion (Misc queries) | |||
cell height changing when using autofill | Excel Discussion (Misc queries) | |||
right click autofill in 2003 | Excel Discussion (Misc queries) | |||
Autofill issue... | Excel Discussion (Misc queries) | |||
Stop autofill icon from appearing? | Excel Discussion (Misc queries) |