• 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

Deepak

Excel Ninja
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),"")
 
Top