Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Offset & Row functions together

Status
Not open for further replies.

ebisabes

Technical User
Aug 11, 2006
71
US
=OFFSET($A$1,ROW()*3-1,0)

can I use a formula like this one if I am using a different tab & I want every 8th number instead of 3rd & how? it doesn't work correctly just to replace $A$1 with the cell I want to start with (whichi is in a different tab)
 
=OFFSET(Sheet1!$A$1,ROW()*4-1,0)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.
 



What? This wasn't tip enough as an example?
[tt]
=INDIRECT("A"&(ROW()-1)*7+1)
[/tt]
Was there a question?

Skip,

[glasses] [red][/red]
[tongue]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top