| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the next record in a column | Excel Discussion (Misc queries) | |||
| Finding Duplicate Record in more than one column | Excel Discussion (Misc queries) | |||
| Finding and Amending a record | Excel Programming | |||
| Finding last record in month for each of several types of record. | Excel Programming | |||
| Automate Finding Values/Copy to Different Sheet | Excel Programming | |||
Threaded Mode
