Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Held dragging INDIRECT FUNCTION
Im using this function.........
INDIRECT($A$2 & "!Q1") When I drag it down a column I want the Q to increment. If anyone can help me with this it would be much appreciated! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Held dragging INDIRECT FUNCTION
Hi!
Try this: =OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1) When copied down will return references to: Sheet!???Q1 Sheet!???R1 Sheet!???S1 Sheet!???T1 etc Biff "ChronicTiger" <u17652@uwe wrote in message news:5a5b756ad125f@uwe... Im using this function......... INDIRECT($A$2 & "!Q1") When I drag it down a column I want the Q to increment. If anyone can help me with this it would be much appreciated! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Held dragging INDIRECT FUNCTION
Thanks I'll keep that one in my arsenal. I am also trying to modify your
equation to get it to return references to: sheet!???Q1 sheet!???Q2 ect.... can you help with that? Thanks Biff.................. Biff wrote: Hi! Try this: =OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1) When copied down will return references to: Sheet!???Q1 Sheet!???R1 Sheet!???S1 Sheet!???T1 etc Biff Im using this function......... [quoted text clipped - 3 lines] If anyone can help me with this it would be much appreciated! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Held dragging INDIRECT FUNCTION
Hi!
Try one of these: =INDEX(INDIRECT(A$2&"!Q:Q"),ROWS($1:1)) =OFFSET(INDIRECT(A$2&"!Q1"),(ROWS($1:1)-1)*1,) Biff "ChronicTiger" <u17652@uwe wrote in message news:5a5cb72708eef@uwe... Thanks I'll keep that one in my arsenal. I am also trying to modify your equation to get it to return references to: sheet!???Q1 sheet!???Q2 ect.... can you help with that? Thanks Biff.................. Biff wrote: Hi! Try this: =OFFSET(INDIRECT(A$2&"!Q1"),,(ROWS($1:1)-1)*1) When copied down will return references to: Sheet!???Q1 Sheet!???R1 Sheet!???S1 Sheet!???T1 etc Biff Im using this function......... [quoted text clipped - 3 lines] If anyone can help me with this it would be much appreciated! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Held dragging INDIRECT FUNCTION
Biff,
Your the man. signed, Mcfly Biff wrote: Hi! Try one of these: =INDEX(INDIRECT(A$2&"!Q:Q"),ROWS($1:1)) =OFFSET(INDIRECT(A$2&"!Q1"),(ROWS($1:1)-1)*1,) Biff Thanks I'll keep that one in my arsenal. I am also trying to modify your equation to get it to return references to: [quoted text clipped - 28 lines] If anyone can help me with this it would be much appreciated! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using INDIRECT in INDEX(LINEST.. ) function | Excel Worksheet Functions | |||
include INDIRECT function into SUMPRODUCT formula | Excel Worksheet Functions | |||
INDIRECT Function - what am I doing wrong? | Excel Discussion (Misc queries) | |||
Using INDIRECT function to specify source data | Charts and Charting in Excel | |||
Using Indirect Function | Excel Worksheet Functions |