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

matching

A

Afarag

Member
Dears,

please i ask for help as i have to pivot tables with a same headers but from different source, and i have slicer that filter the 1st table only and the 2nd table standing, and i have a formula that get some results based on both of 2 tables when use filtering, i ask to add matching the headers in the used formula

=SUM(B5:B12)/(SUMPRODUCT(ISNUMBER(MATCH($A15:$A22,$A$5:$A$12,0))*B15:B22))
 

Attachments

Hi Afarag,

Can you explain the logic of what you are trying to get? Can you tell if you change filter from slicer what changes should occur on the result.

Regards,
 
say i select "sales" from slicer the formula should occur to "Sales" but not "Business", i ask to the formula reflect with what i choose from slicer, as the function is based on the same header columns in both of 2 table


Thanks,
 
@Audi,

OK but if i select more than One figure only the first one that shown,and if i select random figure, i want the formula is matched with what i selected from slicer
 
@Audi,

it's really get what i'm looking for but the attached sheet is a sample when i applied your function to the main sheet it do nothing although it's the same data as i copied it to the sample,
appreciate if take a look to the main sheet perhaps know the problem
 

Attachments

You must log in or register to reply here.
Back
Top