Find Similar suppliers of Different Items in Pivot table

[ndmalam]

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.

[#2]

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

[#3]

@NikolinoDE 

Yes it is what i was looking for

please explain COUNT step by step to help me.

best regards

[#4 · Accepted solution]

@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)