• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

NEED HELP "FILTER" OPTION

When I select one category by filter, category show in specific cell.

Check attach file.
 

Attachments

  • Filter Help.xlsx
    12.8 KB · Views: 11
Or, This would be far better..

=IF(SUBTOTAL(3,$A$6:$A$26)<>COUNTA($A$6:$A$26), INDEX($A$6:$D$26,MATCH(SUBTOTAL(105,$A$6:$A$26),$A$6:$A$26,0),4),"")
 
Back
Top