I have a autofiltered data range from which I calculate a number of subtotals.

I.e: column 2 filtered to show "tool A"

- how do I get the value "tool A" to a cell outside the filtered data range
by using a worksheet function?

rgds!