Obtain cell reference below the header of a filtered range.
Hi,
I have a sheet of data with a filter on the headings. Is there a formula that would obtain the a cell reference from column A from the first row of the filtered data. For example, once a filter is selected the first row could be line 100 but next time a different filter is selected the first line could be 50. I would be grateful for any help.
Thank you
Hello Peter,
Assuming header is in row 1, A2:A100 is data, so try this formula,
=CELL("address",INDEX(A2:A100,MATCH(1,INDEX(SUBTOTAL(3,OFFSET(A2,ROW(A2:A100)-ROW(A2),)),0),0)))
Change cell reference.
Regards,
Haseeb Avarakkan
__________________________________
"Feedback is the breakfast of champions"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks