Hello,

I have a filtered block of data, and I filter on items in column L, say. I've picked up a formula from an Excel website, which shows in a cell which item in that column I'm filtering on :

{=INDEX(L2:L10000,MIN(IF(SUBTOTAL(3,OFFSET(L2,ROW(L2:L10000)-ROW(L2),0)),ROW(L2:L10000)-ROW(L2)+1)))}

It works fine, but I'd be grateful, if someone could explain to me in simple terms, what the formula actually does - I particularly lose the plot when it comes to the array brackets.

Thanks

TimC