| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to copy cells data in every 7th row?
=Indirect("A" & (row()-1)*7+2) in B1 then drag fill down.
-- Regards, Tom Ogilvy "Jeff" wrote in message ... Hi, I have a column of data from A2 to A65000 and I am only interested in every 7th data point (e.g. A2, A9, A16....). Is there a way to get those selected points and store them in the next column (B) consecutviely (b1, b2, b3, b4, ...)? Thanks, Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy data of two cells into one | Excel Discussion (Misc queries) | |||
| Copy data of two cells into one | Excel Discussion (Misc queries) | |||
| how to copy cells data in every 7th row? | Excel Worksheet Functions | |||
| Copy data into cells until changes trigger new copy | Excel Programming | |||
| How do I copy data (word) into respective cells when the data bei. | New Users to Excel | |||
Hybrid Mode
