Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look for value that is six columns apart
I have a spreadsheet that has a diffent column title every six columns. The
data for the spreadsheet is coming from a query. How can I reference the columns that are at a constant of six columns apart? For example: Column A B C D E F Part 1 XX XX XX XX Part 2 I need for the formula to reference Part 2, and subsequently Part 3 located in column L, row 1. Thanks, Pablo |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look for value that is six columns apart
Have a look in the help index for OFFSET
-- Don Guillett Microsoft MVP Excel SalesAid Software "Pablo" wrote in message ... I have a spreadsheet that has a diffent column title every six columns. The data for the spreadsheet is coming from a query. How can I reference the columns that are at a constant of six columns apart? For example: Column A B C D E F Part 1 XX XX XX XX Part 2 I need for the formula to reference Part 2, and subsequently Part 3 located in column L, row 1. Thanks, Pablo |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Look for value that is six columns apart
With Part 2 in Column F,
Part 3 in Column L, Part 4 in Column R, .... etc. If copying *down*, use: =INDEX($1:$1,6*ROWS($1:1)) If copying *across*, use: =INDEX($1:$1,6*COLUMNS($A:A)) -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Pablo" wrote in message ... I have a spreadsheet that has a diffent column title every six columns. The data for the spreadsheet is coming from a query. How can I reference the columns that are at a constant of six columns apart? For example: Column A B C D E F Part 1 XX XX XX XX Part 2 I need for the formula to reference Part 2, and subsequently Part 3 located in column L, row 1. Thanks, Pablo |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
putting 2 long columns into multiple columns in excel page and sor | Excel Discussion (Misc queries) | |||
to convert columns to rows having mulit independent group columns | Excel Worksheet Functions | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) |