Dynamic Ranges & Invisible Offset

[Guest]

I am comfortable working with Dynamic Ranges that expand and contract
automatically, based on =offset()

Example here:
http://www.ozgrid.com/Excel/DynamicRanges.htm


I am trying to figure out another way to do this. I am working with a model
that someone else designed. He is no longer with the company so I can’t ask
him how he crated this dynamic offset, but it works on the same principal as
the =offset() function mentioned above. All I can see is a blue border
around the list of data that is being offset from. Also, there is a small
blue asterisks in the lower left hand corner of the list…this seems to
indicate the last row (which is blank) of this otherwise invisible offset
feature. Can anyone shed some light on this topic for me?

Regards,
Ryan---

 

[Guest]

this is called a LIST and was a new feature added in Excel 2003.

With this area selected,
In the menus, go to Data=>List and you should have a bunch of choices.

if you want to create one, create a table like you would use for Autofilter
and select it, then do Data=>List=>Create List

 

[Guest]

Whoa! You are correct! I have never used this feature before, but I will be
researching it shortly, and will almost certainly be using it in the very
near future.
Thanks so much!
Ryan---