How specify a range of every nth cell?

[browns87]

Hello,

I want to analyze the data from every 10th cell in column composed of 1000 rows (ie cells A10, A20, A30 ... A980, A990, A1000). When entering a formula, how do I specify the range which includes these 100 relevant cells, but excludes the 900 irrelevant cells?

extraneous information:
I am familiar with the use of the formula MOD(ROW(A1),10) to specify a range, but it does not work when trying to specify this range in a formula.
version: Excel 2007
OS: Win XP (and Win 7)

Thanks in advance.

 

[MrKowz]

Welcome to the forums!

Try using:

INDIRECT(ADDRESS(MOD(ROW(A1),10),1,4))