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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove punctuation mark, Split cells & average accross column 4
multiple entries per cell to save on table size? 3
Need to number but skip blank rows 7
let's try it one more time 1
Problem w/formula referencing another sheet 1
Autofill Format 3
autofill down won't work!!!! 3
Excel - eliminating repeated data 3

Top