| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you select every 8th cell
Fantastic
thanks "bj" wrote: what do you mean by "get"? do you want to sum? =sumproduct(--(mod(row(A2:A200),8)=2),A2:A200) do you want the data to show in another location =index(A:A,(row()-1)*8+2 put into row 1 and copied down. there are other options depending on what you want to do. "JBW" wrote: I want to grab the data from cells A2/A10/A18 etc I thought if I did the first few and then selected them all and copied that excel would get the idea and grab every 8th one, but it doesn't Is there a formala that can say get cell that is previous one plus 8 rows? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using formulas to select cells (Ex: Select every nth cell in a col | Excel Discussion (Misc queries) | |||
| How to point to (select) a cell to the left from a cell where I enter the = equal sign? | Excel Discussion (Misc queries) | |||
| select cell value based on value in adjacent cell | Excel Worksheet Functions | |||
| I cannot select a single cell or pull down cell contents | Excel Worksheet Functions | |||
| Select cell, Copy it, Paste it, Return to Previous cell | Excel Discussion (Misc queries) | |||
Threaded Mode
