Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I prevent a formula element from incrementing when copying | Excel Worksheet Functions | |||
Transform a Cell from Formula to Number | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) | |||
Is it possible to change the "result of a formula" to a "number? | Excel Discussion (Misc queries) |