| 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 |
| 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) | |||
Threaded Mode
