Fill Cells with same number in three rows then skip to next number
 

I need to fill cells using the same number three times and then the next
number three times and so on: Each time I drag to fill it adds a row and the
numbers change to 178.999303.

178
178
178
179
179
179
--
Tracy

Fill Cells with same number in three rows then skip to next number
 

A1: 178
A2: 178
A3: 178
A4: =A1+1
Copy down as needed. Then, if you want these numbers to be actual numbers,
and not formulas anymore, select your column of data, copy it, then paste
special: values over the top of itself.

--
** John C **
Please remember if your question is answered, to mark it answered :). It
helps everyone.


"Tracy" wrote:

I need to fill cells using the same number three times and then the next
number three times and so on: Each time I drag to fill it adds a row and the
numbers change to 178.999303.

178
178
178
179
179
179
--
Tracy

Fill Cells with same number in three rows then skip to next number
 

In A1: 178

In A2: =A1+(MOD(ROW()-1,3)=0)

copy down as far as needed



"Tracy" wrote:

I need to fill cells using the same number three times and then the next
number three times and so on: Each time I drag to fill it adds a row and the
numbers change to 178.999303.

178
178
178
179
179
179
--
Tracy