Nov 26 2020 09:09 AM
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.
Nov 26 2020 12:11 PM
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.
Nov 26 2020 06:38 PM
Yes it is what i was looking for
please explain COUNT step by step to help me.
best regards
Nov 26 2020 11:51 PM
Solution
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)
Nov 26 2020 11:51 PM
Solution
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)