View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Max Max is offline
external usenet poster
 
Posts: 9,221
Default how do I select every third cell in a row in excel?

I've just responsed earlier with a generic

With your specifics defined in your reply here
In your startcell, place this:
=OFFSET('Data Input'!$D$107,ROWS($1:1)*3-3,)
Then just copy it down as far as required
It'll return exactly what you're after

Celebrate your success, click the YES button below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Tiger" wrote:
I have a spreadsheet that has 2 worksheets, one called "Chart Feed" and the
other one called "Data Input". I am in the "Chart Feed" worksheet and I am
trying to reference every third cell in the 4th column of "Data Input". So,
my column on "Chart Feed" looks like this:

=+'Data Input'!D107
=+'Data Input'!D111
=+'Data Input'!D115
=+'Data Input'!D119

As you can see, I'm "grabbing" every third cell from the "D" Column in "Data
Input" worksheet. Right now I'm having to write each of these cells by hand.
It seems to me that there's a way I can ge Excel to grab the correct cell on
it's own. E.g. I tried writing =+'Data Input'!D(D107+3), and, off course, it
doesn't work. But there should be something like that.

Anyone has any ideas. And thanks so much