View Single Post
  #1   Report Post  
Bowbender
 
Posts: n/a
Default Incrementing a formula by X number


Hello All,

I have yet another one which I am sure most of you know the answer to.
To set it up, here it goes. I have a worksheet named Results and in
this worksheet I have around 25,000 different numbers in the B column.
Out of all those, I want to get every 20th one and put that value into a
worksheet called Sheet2 lets say. I obviously don't want to hand type
in

=Results!B20
=Results!B40
=Results!B60
etc...

Is there a way I can use a more sophisticated(sp?) formula, so that I
can just drag down and have it fill automatically?

Thanks in advance


--
Bowbender
------------------------------------------------------------------------
Bowbender's Profile: http://www.excelforum.com/member.php...fo&userid=9611
View this thread: http://www.excelforum.com/showthread...hreadid=469532