how do I select every third cell in a row in excel?

T

Tiger

I'm trying to select every third cell in a column in a different worksheet
than the one I'm using and I don't know if you can do this in Excel. E.g. I
want to reference in the current worksheet every third cell in another
worksheet. I want Excel to look down the column and select every third cell.
Can anyone help? It's difficult to ask the question. Thanks.
 
S

Shane Devenshire

Hi,

are you trying to build a formula or what? And if a formula please show us
the formula you are trying to construct.
 
T

Tiger

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

Tiger
 
M

Max

Let's say you want to extract
what's in Sheet2's col A (in A1, A4, A7, etc) into Sheet1

In Sheet1, you could place this in any startcell,
say, in E2: =OFFSET(Sheet2!$A$1,ROWS($1:1)*3-3,)
then just copy E2 down as far as required

"Growl" your success here, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
M

Max

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
 
S

Shane Devenshire

Hi,

Try this

=INDIRECT("'Data Input'!D"&103+ROW(A1)*4)

A little sidebar: you don't need to type =+ Just type = its quicker, and
your spreadsheet is smaller and who knows maybe it even calculates faster.

Both INDEX and OFFSET can also be used.
 
M

Max

Correction. Looks like it should have been "4" in the expression:
=OFFSET('Data Input'!$D$107,ROWS($1:1)*4-4,)

Think I was misled earlier by your descript: "every 3rd cell"
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top