Pulling out every nth value

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nth row or column counting 1
every nth cell by columns not rows.... 1
Return the value from one range that does not exist in another 0
Return nth value from list 5
sum last nth cells 4
Is there a way to use a multiple column array in SUMPRODUCT? 2
Sum of every nth cell in a column 3
How do I count the number of entries of specifc criteria is met 2

Top