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

I need help on pivot table

Hi,

Without macro you will not be able to change the filter in the pivot

Instead of using a pivot use an array formula as below

Note: Hit ctrl+shift+enter after entering the formula

=INDEX(DATA!$B$2:$B$20,SMALL(IF(DATA!$C$2:$C$20=$H$1,ROW(DATA!$C$2:$C$20)),ROW(1:1))-1,1)
 
Sathish KV said:
Hi,

Without macro you will not be able to change the filter in the pivot

Instead of using a pivot use an array formula as below

Note: Hit ctrl+shift+enter after entering the formula

=INDEX(DATA!$B$2:$B$20,SMALL(IF(DATA!$C$2:$C$20=$H$1,ROW(DATA!$C$2:$C$20)),ROW(1:1))-1,1)
Click to expand...
thank u boss
 
You must log in or register to reply here.
Back
Top