Thread
:
Look for value that is six columns apart
View Single Post
#
2
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett