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. |
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 |
All times are GMT +1. The time now is 05:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com