• 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


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to extract the different text having same value in comparative statement.

I am preparing the 80:20 rule by knowing the top 10 items of vendor A corresponding how the other vendor quoted.
Using the large function, I arrived the top 10 items of vendor- A in column C 32: to C41, based on the value in C I arrived the name in Column B32 to B41.
ow B31 and B32 I am getting the name "A" only instead of A & X.
Please help me getting the name A & X in Row B31 & B32.


  • Top 10 items-.xlsx
    17.9 KB · Views: 3
A pivot table will do this sort of thing for you in its stride. See cell K31 table in the attached.


  • Chandoo54739Top 10 items-.xlsx
    23.5 KB · Views: 2