468,550 Members | 2,480 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,550 developers. It's quick & easy.

"range pointers" in MS Excel

Dormilich
8,651 Expert Mod 8TB
Hi,

Iím doing some statistics in Excel (ok, simple statistics) and I wonder if there is a possibility to automatically copy the input parameters in the functions

say, A(), B() & C() are statistical functions
Expand|Select|Wrap|Line Numbers
  1. A(A1:A5;B1:B5)
  2. B(A1:A5;B1:B5)
  3. C(A1:A5;B1:B5)
so if I use the next set of values (usually I copy it over) I need to revise and change the used range (e.g. from A1:A5/B1:B5 to A2:A7/B2:B7). with just the 3 functions this would be ok, but usually I have at least 5 such triples, which is always a lot to copy.

so, is there a possibility that I can use a kind of pointer where I only need to change the range once per triple?
Expand|Select|Wrap|Line Numbers
  1. A(pX;pY) // or A(pXY) Ö
  2. B(pX;pY)
  3. C(pX;pY)
I suspect this could be done via Macro, but I couldnít find anything useful.

thanks, Dormi
Sep 21 '09 #1

✓ answered by improvcornartist

Could the Indirect function work? Set up the ranges, then call them using indirect?

2 1353
improvcornartist
303 Expert 100+
Could the Indirect function work? Set up the ranges, then call them using indirect?
Sep 22 '09 #2
Dormilich
8,651 Expert Mod 8TB
It worked, thank you very much.
Sep 22 '09 #3

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

388 posts views Thread by maniac | last post: by
46 posts views Thread by TTroy | last post: by
1 post views Thread by tkpmep | last post: by
8 posts views Thread by sam | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.