Hello! I have asked a similar question about this but I did not get a
satisfactoty answer. I have two columns; A and B. In column A I have a list
of interest rates for different days. Since I am only interested in the
interest rate on certian days I want to single out these days and put them in
column B. I want to use every fifth interest rate that is found in column A,
e.g. I want to use only interest rates on fridays.

Thus. my question is: How to I fill column B with every fifth entry found in
A?
Here is an example of what I mean. Cell A5=2,25. Cell A10=2,45. Cell
A15=2,44. Thus, I want B1=2,23. B2=2,45 and B3=2,44.

This seems simply enough but I have not really managed. Is it possible to do
something similar to the R1C1 notation that you can use in VBA? Any help is
very much appreciated! Thank you very much!