Assuming that you'd like to return the relevant values in Column A,
starting at A2, try...

A2, copied down:

=INDEX(Store,LOOKUP(2,1/SUBTOTAL(3,OFFSET(Store,ROW(Store)-MIN(ROW(Store)
),0,1)),ROW(Store)-MIN(ROW(Store))+1),ROWS($A$2:A2))

....confirmed with just ENTER, or

=INDEX(Store,MATCH(2,1/SUBTOTAL(3,OFFSET(Store,ROW(Store)-MIN(ROW(Store))
,0,1))),ROWS($A$2:A2))

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article <60d2f1fa408bc@uwe, "Sam via OfficeKB.com" <u4102@uwe
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