andydtaylor
Active Member
- Joined
- Feb 15, 2007
- Messages
- 355
- Office Version
-
- 2010
Hi,
I know I can do this as a name:
=Sheet2!$A:$A,Sheet2!$D:$D,Sheet2!$G:$G,Sheet2!$J:$J
But is something like the following possible?
=OFFSET(INDIRECT(Calcs_Product_IDs!$A:$2,Calcs_Product_IDs!$D:$2,Calcs_Product_IDs!$G:$2,Calcs_Product_IDs!$J:$2),0,0,(COUNTA(INDIRECT("Product_IDs!$A:$A"))-1))
Thanka,
Andrew
I know I can do this as a name:
=Sheet2!$A:$A,Sheet2!$D:$D,Sheet2!$G:$G,Sheet2!$J:$J
But is something like the following possible?
=OFFSET(INDIRECT(Calcs_Product_IDs!$A:$2,Calcs_Product_IDs!$D:$2,Calcs_Product_IDs!$G:$2,Calcs_Product_IDs!$J:$2),0,0,(COUNTA(INDIRECT("Product_IDs!$A:$A"))-1))
Thanka,
Andrew