Hi Guys,
I need to create a Formula, that returns every 13th cell, in column B, for Instance underneath each other.
I have a set of Dates, with 13 Values for each date In Collumn B) In Row D1, I need to return the Value in C1, in D2, I need to return the Value in C13, in D3, I need to return the value in C26, in D4, return C39, So every 13th cell value ?
How would I do this. I am new to excel, and read a Bit on the ofset, the ofset works for the 1st Cell, but not the next (when copied down) uses the Ref C1, and then next one down C2 + 13 for example what is not what I want
Bookmarks