How to return every Nth value in a column in Excel?
October 26, 2009 9:45 AM Subscribe
I am trying to pull values from one sheet into another master sheet for daily trending. The OFFSET function works for a single cell, but I can't figure out how to copy that formula to the rest of the column.
posted by malcommc to Work & Money (13 answers total) 1 user marked this as a favorite
Here's an example.
The total sheet uses dates and revenue. The values come from second sheet, every 5th cell in column D, starting with D5.
10/19/09 (Second Sheet, D5)
10/20/09 (Second Sheet, D10)
10/21/09 (Second Sheet, D15)
10/22/09 (Second Sheet, D20)
I literally have hundreds of these, so picking each value would be tedious and prone to error. Any help is appreciated.