- May 22, 2009
Hi All, I would like to capture the filtered data under a header using a formula in another cell. For e.g. In Column A I have a header Salesman (A1) Under this header i have values John (A2), Dennis (A3), Michael (A4), Vicky (A5) Suppose I applied autofilter in A1:A5 and filter Dennis, then i should get B1 as Dennis, If i filter John, then B1 should be John. Can i do this using some formula?