Just discovered use for named ranges...

[Big Monkey]

Oh my GOD! Reading a random thread on here, and I just discovered how to use formulas in named ranges!! This is amazing. I also learned about 3-D references.

I feel like a complete newbie now :| I can't believe what a headache I've been putting myself through before now.

I lub this forum

 

[shajueasow]

That would have been more amazing if you have posted a link to that thread, so that some others will also benefit from it.

 

[Big Monkey]

I didn't read a tutorial type thread, the question actually wasn't answered. I just saw someone said formulas in named ranges and then used the help menu in excel and it had a related answer about 3-D references.

I read all I could and then started playing around.

I could try to answer some basic questions if you have any.

 

[erik.van.geit]

and did you read about dynamic ranges
you will be amazed again
this is very nice:
http://www.datapigtechnologies.com/flashfiles/dynamicranges.html

kind regards,
Erik

 

[PaddyD]

"... it had a related answer about 3-D references. "

& if you want something really fancy that uses named ranges to to 3-D calculations, doesn't come much more elaborate than:

http://j-walk.com/ss/excel/eee/eee003.txt

...enjoy!

 

[MarkAndrews]

and did you read about dynamic ranges
you will be amazed again
this is very nice:
http://www.datapigtechnologies.com/flashfiles/dynamicranges.html

kind regards,
Erik

Very useful - Thanks Erik