| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
offset every nth column
Refer to post Every nth cell. I need this to work for every third column
instead of row but can not get the formula to work. I want to type in the formula and copy it right to pull every third column's value. The formula used in the previously referenced post is offset. |
|
#2
|
|||
|
|||
|
One way
=OFFSET($A$3,,COLUMN(A:A)*3-3) copied across to the right -- Regards, Peo Sjoblom "Sampson" wrote in message ... Refer to post Every nth cell. I need this to work for every third column instead of row but can not get the formula to work. I want to type in the formula and copy it right to pull every third column's value. The formula used in the previously referenced post is offset. |
|
#3
|
|||
|
|||
|
"Peo Sjoblom" wrote: One way =OFFSET($A$3,,COLUMN(A:A)*3-3) copied across to the right -- Regards, Peo Sjoblom "Sampson" wrote in message ... Refer to post Every nth cell. I need this to work for every third column instead of row but can not get the formula to work. I want to type in the formula and copy it right to pull every third column's value. The formula used in the previously referenced post is offset. This Works Perfectly. Thank you for your Help. It is much appreciated. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I sort by row instead of by column? | Excel Worksheet Functions | |||
| Format cell in column B based on value in the next cell (column c) | Excel Discussion (Misc queries) | |||
| VLOOKUP, OFFSET, MATCH PROBLEM, HELP? | Excel Worksheet Functions | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Linear Mode
