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!

Register Log in
  • 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

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)
 
Sort by date Sort by votes
=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.
 
Upvote 0 Downvote



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]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

remeng
  • Locked
  • Question
Excel Pivot Table - Combine Values into a single row
Replies
16
Views
2K
remeng
remeng
remeng
  • Locked
  • Question
Power Query Split by Table Group by Rows into a new set of group by tables
Replies
2
Views
298
remeng
remeng
ladyck3
  • Locked
  • Question
Excel 365 – (Formula/Function for Hyperlinks) and (Totals Yearly & Quartly) 2
2
Replies
24
Views
835
ladyck3
ladyck3
ladyck3
  • Locked
  • Question
Excel 365: I'm new to Tables - Configuring Font & "Get Data from Table/Range" 2
Replies
4
Views
346
ladyck3
ladyck3
GPnew
  • Locked
  • Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
1K
combo
combo

Part and Inventory Search

Sponsor

Back
Top