Enter this *anywhere*, and drag across to copy as needed:

=INDEX(18:18,3*COLUMNS($C:C))

--

HTH,

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

"CNN" <cxvcvxcvxcv wrote in message
...
I'm trying to fill cells across a row. The first cell references C18, the
next F18, the one after that I18 and so on i.e two cell are to be skipped to
get to the next value I want. However, after i fill the first 3 values
manually and drag the fill handle after selecting all three the next value
to
be filled in is F18, then I18, L18, I18 and so on. Is there a way to make
the
fill follow the series I want it to?
The problem persists even if I fill 5 cell manually.