Consulting

Results 1 to 4 of 4

Thread: result of filter

  1. 09-15-2015, 08:19 AM #1
    amrane
    amrane is offline
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location

    result of filter

    Dear forum,
    I am looking to get the result of filter using formula under excel!!!

    so far I found 1/2 response: the brown cells are the result of each column independently.

    ==> what formula to get result as per the yellow cells: result based on two column in the same time??

    Looking for your support,
    br, Amrane
    Attached Files Attached Files
    Reply With Quote Reply With Quote
  2. 09-15-2015, 09:45 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    would a pivot table do? See attached.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  3. 09-15-2015, 10:53 AM #3
    amrane
    amrane is offline
    VBAX Regular
    Joined
    Jan 2011
    Posts
    55
    Location
    dear Mr p45cal,

    thank you so much for your feedback,

    but, I want to get some array formula to mange this case of calculation,
    Br, Amrane
    Reply With Quote Reply With Quote
  4. 09-16-2015, 04:33 AM #4
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    With a helper column I.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules