1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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

Discussion in 'Ask an Excel Question' started by Mohammad Younous, Jan 9, 2019.

  1. Mohammad Younous

    Mohammad Younous Member

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

    Check attach file.

    Attached Files:

  2. pecoflyer

    pecoflyer Active Member

    Messages:
    291
  3. Deepak

    Deepak Excel Ninja

    Messages:
    2,878
    Check this...

    =INDEX($A$6:$D$26,MATCH(SUBTOTAL(105,$A$6:$A$26),$A$6:$A$26,0),4)
  4. Deepak

    Deepak Excel Ninja

    Messages:
    2,878
    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),"")
    Thomas Kuriakose likes this.
  5. Mohammad Younous

    Mohammad Younous Member

    Messages:
    43
    It working thanks a lot.

Share This Page