Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pulling out every nth value
Hello,
Is there a function I can use to pull out every nth value from a range of values. i.e. Column A contains 100 values I wish to pull out every 4th value and place them in Column B Column B would now contain 25 values -- Thank-you and all suggestions are appreciated. |
#2
|
|||
|
|||
One way:
B1: =INDEX(A:A,(ROW()-1)*4+1) In article , Anauna wrote: Hello, Is there a function I can use to pull out every nth value from a range of values. i.e. Column A contains 100 values I wish to pull out every 4th value and place them in Column B Column B would now contain 25 values |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pulling data out of a large database | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Help creating a formula, pulling from a set of static numbers. | Excel Worksheet Functions | |||
Pulling hair out with VLOOKUP | Excel Worksheet Functions | |||
pulling characters out of a string | Excel Worksheet Functions |