Hard to visualize what you are asking for...

What is the reference of Store?

If it's a single-column vertical range, "its LAST row" will be a single
cell. Moreoever, is the range nummeric or text?


Sam via OfficeKB.com wrote:
Hi All,

Is there a Formula that can index the Named Range "Store" and retrieve its
"LAST Row" of autofiltered data (visible cells only), and Return the
autofiltered data to / down a Single Column?

Cheers,
Sam