Automate finding every 15th record
Awesome! Thanks.
"mark" wrote:
The answer to your question about whethe you need a formula, macro, or code,
most likely depends upon how often you need to do it. If you only need to do
it once, formulas will do it nicely. If you need to do it a bunch of times,
you'll want to automate it with code.
Here are two formulas that may help:
=ROW(A1)
=MOD(A1,15)
=ROW will tell you the row number of eacy line.
=MOD will result in 0 (the remainder, when the row number is divided by 15)
each time it hits a 15th row.
Hope that helps.
Mark
"jlo" wrote:
I have a spreadsheet and I am trying to develop a list from that spreadsheet.
I need Excel to find the data in every 15th row in column A.
For instance Column A is Name, Column B is Address. I want to generate a
list of every name in Column A for every 15th record.
Would I need a formula, macro or code?
Thanks in advance.
|