Hi,

I have a worksheet using an autofilter and I need to get the value of the
previous visible cell once the filter is applied.

Assuming my formula is in cell A1000 then is there a worksheet function(s)
that can give me the value of the previous visible cell which will change
depending on what filter criteria I have.

Thanks for any help

Fred