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