Both suggestions you got do exactly what you asked for.
What is your problem?
What do you mean with "when it gets a bit more complex"?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Arne Hegefors" wrote in message
...
| Thanks! But I have real trouble with this syntax when it gets a bit more
| complex. There must be some way of writing so that one cell shows the rate
| found in e.g. F10, the next F15, then F20 etc. It seems very easy but as I
| said I have not managed..Any help on this subject is vey much appreciated!
|
| "Max" skrev:
|
| Put in B1, and copy down:
| =INDEX(A:A,ROW(A2)*5-5)
| --
| Max
| Singapore
| http://savefile.com/projects/236895
| xdemechanik
| ---
| "Arne Hegefors" wrote:
| 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!
|
|
|