Forum Discussion

ndmalam's avatar
ndmalam
Copper Contributor
Nov 26, 2020
Solved

Find Similar suppliers of Different Items in Pivot table

Hi,

I want to create a pivot table.

I have a Data table which contains list of Purchased items on different date, from different suppliers , on different Rates.

I want to find which items are supplied by more than one suppliers also showing rate and date .

sample file is attached

Best Regards.

  • ndmalam 

     

    Here some Infos about Pivot:

    Please consider that everything takes and needs time.

    When I was fourteen my father was so ignorant.

    I could hardly stand the old man around me.

    But at twenty-one I was amazed at how much he'd learned in seven years.

    - Mark Twain
    Now I'm exactly as old as he used to be and I miss his ingenuity:).

     

    Get started with Power Pivot in Microsoft Excel

    Get started with Power Pivot in Microsoft Excel - Excel

     

    How to Create Pivot Table in Excel: Beginners Tutorial

    How to Create Pivot Table in Excel: Beginners Tutorial (guru99.com)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

     

    Wish you a nice day.

    Nikolino

    I know I don't know anything (Socrates)

     

     

3 Replies

  • NikolinoDE's avatar
    NikolinoDE
    Platinum Contributor

    ndmalam 

    Quick Pivot for Beginners (one like me  🙂

     

    I would be happy to know if I could help.

     

    Nikolino

    I know I don't know anything (Socrates)

     

    * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

    • ndmalam's avatar
      ndmalam
      Copper Contributor

      NikolinoDE 

      Yes it is what i was looking for

      please explain COUNT step by step to help me.

      best regards

      • NikolinoDE's avatar
        NikolinoDE
        Platinum Contributor

        ndmalam 

         

        Here some Infos about Pivot:

        Please consider that everything takes and needs time.

        When I was fourteen my father was so ignorant.

        I could hardly stand the old man around me.

        But at twenty-one I was amazed at how much he'd learned in seven years.

        - Mark Twain
        Now I'm exactly as old as he used to be and I miss his ingenuity:).

         

        Get started with Power Pivot in Microsoft Excel

        Get started with Power Pivot in Microsoft Excel - Excel

         

        How to Create Pivot Table in Excel: Beginners Tutorial

        How to Create Pivot Table in Excel: Beginners Tutorial (guru99.com)

         

        * Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.

         

        Wish you a nice day.

        Nikolino

        I know I don't know anything (Socrates)