Ramballah
Active Member
- Joined
- Sep 25, 2018
- Messages
- 334
- Office Version
- 365
- Platform
- Windows
Hi,
So the past weeks I've been making a new workbook for work and received amazing help from the people of this community.
And right now I'm on my last puzzle!
I have this power query that reformats information from the raw data for me and works wonders (power query is because the data is dynamic as I add new rows of data every week)
And now I need to have a second table right next to it to basically tell me which items have the highest amount, and tell me how many times each item appeared.
Here is the example:
I have this:
Which is only 50 rows for now. And what I want is this:
It counts how many times certain items are found, so some items are found twice and adds up those qty amounts. Even singular appearances get in this 2nd table. Also, its only for the items with the type "Overcode". I don't need this for the other types only for this. This allows me to find which items are being trashed the most, and which are trashed often.
I also don't care if this is with formulas or power query or macro's. It's my own workbook! I hope this information is enough, if not feel free to ask!
Thanks in advance,
Ramballah
*edit* added a picture for reference, and some items appear like 5-10 times with different amount, in this example it just happened that only a few appeared multiple times with only 1 on the amount column. So the amounts can be 5+7 aswell for example!
So the past weeks I've been making a new workbook for work and received amazing help from the people of this community.
And right now I'm on my last puzzle!
I have this power query that reformats information from the raw data for me and works wonders (power query is because the data is dynamic as I add new rows of data every week)
And now I need to have a second table right next to it to basically tell me which items have the highest amount, and tell me how many times each item appeared.
Here is the example:
I have this:
Date | Wk | Code | Name | Amount | Totaal | Type | Group |
22/07/2024 | 30 | 23077 | BLIJKI VRIJ UITL OMEGA 3 | 5 | € 13,65 | Overcode | Eieren |
22/07/2024 | 30 | 432527 | OPTIME DRINK BANAAN 1L | 1 | € 1,99 | Overcode | Drink |
22/07/2024 | 30 | 178334 | DANONE SPRINKLINS 2P | 1 | € 1,89 | Overcode | Eet |
22/07/2024 | 30 | 209076 | ARLA LACTOFREE HV YOGHURT | 2 | € 4,50 | Overcode | Eet |
22/07/2024 | 30 | 499687 | I SKYR SKYR TOP CARAMEL | 2 | € 5,46 | Overcode | N.V.T. |
22/07/2024 | 30 | 578882 | DANONE M&M YOGHURT | 4 | € 4,52 | Overcode | Eet |
23/07/2024 | 30 | 65689 | OPTIME DRINK AARDB/KERS | 1 | € 1,95 | Overcode | Drink |
23/07/2024 | 30 | 74004 | CAMPIN HV MELK 2.4 L | 1 | € 2,90 | Overcode | Drink |
23/07/2024 | 30 | 347824 | OPTIME DRINK AARDBKERS1.5 | 2 | € 5,12 | Overcode | Drink |
23/07/2024 | 30 | 347825 | OPTIME DRINK FRAMBS 1.5L | 1 | € 2,61 | Overcode | Drink |
23/07/2024 | 30 | 594245 | ACTIME SINAASAPPEL 4PK | 9 | € 21,06 | Overcode | Drink |
23/07/2024 | 30 | 121010 | MONA PUDDING TOETJE VDM | 2 | € 5,08 | Overcode | Eet |
23/07/2024 | 30 | 174433 | LINDAHLS KVARG VANILLE | 2 | € 5,30 | Overcode | Eet |
23/07/2024 | 30 | 193264 | JUMBO KNIJPKWRK AARDB 4P | 1 | € 1,57 | Overcode | Eet |
23/07/2024 | 30 | 576940 | EHRMANN PROT PUDD CARAMEL | 5 | € 8,60 | Overcode | Eet |
23/07/2024 | 30 | 576944 | EHRMANN PROT PUD CHOC TOP | 1 | € 1,79 | Overcode | Eet |
23/07/2024 | 30 | 577924 | ALMHOF HOEKJE VENETIE | 3 | € 4,14 | Overcode | Eet |
23/07/2024 | 30 | 578379 | ZHOEVE PROT TOP YOG AARDB | 2 | € 3,50 | Overcode | Eet |
23/07/2024 | 30 | 603216 | ALPRO PROT YOGH TROPICAL | 6 | € 11,58 | Overcode | Eet |
23/07/2024 | 30 | 603217 | ALPRO PROT YOGH ROODFRUIT | 12 | € 23,16 | Overcode | Eet |
23/07/2024 | 30 | 610577 | JUMBO SLAGROOM 35% 125ML | 2 | € 1,98 | Overcode | Eet |
23/07/2024 | 30 | 388397 | JUMBO KWARK VANILLE | 1 | € 1,89 | Breuk | Eet |
24/07/2024 | 30 | 610412 | SCHARREL EI WIT 30 | 1 | € 6,31 | Overcode | Eieren |
24/07/2024 | 30 | 31677 | CAMPIN HALFVOLLE MILDE YO | 1 | € 1,64 | Overcode | Eet |
24/07/2024 | 30 | 221285 | JUMBO BIOGARDE ROERYOGH | 1 | € 1,39 | Overcode | Eet |
24/07/2024 | 30 | 221285 | JUMBO BIOGARDE ROERYOGH | 1 | € 1,39 | Overcode | Eet |
24/07/2024 | 30 | 347423 | CAMPIN KWARK MAGER AARDB | 1 | € 1,99 | Overcode | Eet |
24/07/2024 | 30 | 388396 | JUMBO KWARK AARDBEI | 2 | € 2,98 | Overcode | Eet |
24/07/2024 | 30 | 526979 | CAMPIN VLA CHOCO | 1 | € 1,89 | Overcode | Eet |
24/07/2024 | 30 | 526979 | CAMPIN VLA CHOCO | 1 | € 1,89 | Overcode | Eet |
24/07/2024 | 30 | 578747 | JUMBO VLAATJE DUBBEL | 2 | € 2,78 | Overcode | Eet |
24/07/2024 | 30 | 580961 | VIFIT DRINK BOSVRUCHTEN | 3 | € 4,47 | Overcode | Eet |
24/07/2024 | 30 | 593943 | MELKUN PROT KWARK VANILLE | 2 | € 2,98 | Overcode | Eet |
24/07/2024 | 30 | 102408 | MELKUN HAVERMOUTPAP | 1 | € 2,19 | Breuk | Eet |
24/07/2024 | 30 | 311924 | NEUTR CREME FRAICHE 30% | 1 | € 0,99 | Breuk | Eet |
24/07/2024 | 30 | 578747 | JUMBO VLAATJE DUBBEL | 1 | € 1,39 | Breuk | Eet |
24/07/2024 | 30 | 347423 | CAMPIN KWARK MAGER AARDB | 1 | € 1,99 | Bederf | Eet |
25/07/2024 | 30 | 605273 | JUMBO GEKOOKT 2 STK | 2 | € 1,98 | Overcode | Eieren |
25/07/2024 | 30 | 420594 | JUMBO BIO VOLLE MELK 1L | 1 | € 1,39 | Overcode | Drink |
25/07/2024 | 30 | 376106 | JUMBO VANILLE YOGHURT | 1 | € 1,62 | Overcode | Eet |
25/07/2024 | 30 | 577759 | MELKUN PROT PUDD SALT CAR | 1 | € 1,66 | Overcode | Eet |
25/07/2024 | 30 | 577759 | MELKUN PROT PUDD SALT CAR | 1 | € 1,66 | Overcode | Eet |
25/07/2024 | 30 | 578077 | ZHOEVE BOER N YOGH MU BOS | 4 | € 6,80 | Overcode | Eet |
25/07/2024 | 30 | 612024 | ZHOEVE BOERN YOGH HAGELSL | 3 | € 5,25 | Overcode | Eet |
26/07/2024 | 30 | 602972 | JUMBO GEKLEURDE EIEREN 6 | 1 | € 2,49 | Overcode | Eieren |
26/07/2024 | 30 | 610397 | JUMBO SCHARREL L/XL 10 | 1 | € 4,05 | Breuk | Eieren |
26/07/2024 | 30 | 198297 | OPTIME DRINK AARDBEI 1L | 6 | € 11,34 | Overcode | Drink |
26/07/2024 | 30 | 501100 | JUMBO HV MELK 1.5L BLK | 4 | € 6,64 | Breuk | Drink |
26/07/2024 | 30 | 501100 | JUMBO HV MELK 1.5L BLK | 1 | € 1,66 | Breuk | Drink |
Which is only 50 rows for now. And what I want is this:
Code | Name | Amount | Times | Group |
23077 | BLIJKI VRIJ UITL OMEGA 3 | 5 | 1 | Eieren |
432527 | OPTIME DRINK BANAAN 1L | 1 | 1 | Drink |
178334 | DANONE SPRINKLINS 2P | 1 | 1 | Eet |
209076 | ARLA LACTOFREE HV YOGHURT | 2 | 1 | Eet |
499687 | I SKYR SKYR TOP CARAMEL | 2 | 1 | N.V.T. |
578882 | DANONE M&M YOGHURT | 4 | 1 | Eet |
65689 | OPTIME DRINK AARDB/KERS | 1 | 1 | Drink |
74004 | CAMPIN HV MELK 2.4 L | 1 | 1 | Drink |
347824 | OPTIME DRINK AARDBKERS1.5 | 2 | 1 | Drink |
347825 | OPTIME DRINK FRAMBS 1.5L | 1 | 1 | Drink |
594245 | ACTIME SINAASAPPEL 4PK | 9 | 1 | Drink |
121010 | MONA PUDDING TOETJE VDM | 2 | 1 | Eet |
174433 | LINDAHLS KVARG VANILLE | 2 | 1 | Eet |
193264 | JUMBO KNIJPKWRK AARDB 4P | 1 | 1 | Eet |
576940 | EHRMANN PROT PUDD CARAMEL | 5 | 1 | Eet |
576944 | EHRMANN PROT PUD CHOC TOP | 1 | 1 | Eet |
577924 | ALMHOF HOEKJE VENETIE | 3 | 1 | Eet |
578379 | ZHOEVE PROT TOP YOG AARDB | 2 | 1 | Eet |
603216 | ALPRO PROT YOGH TROPICAL | 6 | 1 | Eet |
603217 | ALPRO PROT YOGH ROODFRUIT | 12 | 1 | Eet |
610577 | JUMBO SLAGROOM 35% 125ML | 2 | 1 | Eet |
610412 | SCHARREL EI WIT 30 | 1 | 1 | Eieren |
31677 | CAMPIN HALFVOLLE MILDE YO | 1 | 1 | Eet |
221285 | JUMBO BIOGARDE ROERYOGH | 2 | 2 | Eet |
347423 | CAMPIN KWARK MAGER AARDB | 1 | 1 | Eet |
388396 | JUMBO KWARK AARDBEI | 2 | 1 | Eet |
526979 | CAMPIN VLA CHOCO | 2 | 2 | Eet |
578747 | JUMBO VLAATJE DUBBEL | 2 | 1 | Eet |
580961 | VIFIT DRINK BOSVRUCHTEN | 3 | 1 | Eet |
593943 | MELKUN PROT KWARK VANILLE | 2 | 1 | Eet |
605273 | JUMBO GEKOOKT 2 STK | 2 | 1 | Eieren |
420594 | JUMBO BIO VOLLE MELK 1L | 1 | 1 | Drink |
376106 | JUMBO VANILLE YOGHURT | 1 | 1 | Eet |
577759 | MELKUN PROT PUDD SALT CAR | 2 | 2 | Eet |
578077 | ZHOEVE BOER N YOGH MU BOS | 4 | 1 | Eet |
612024 | ZHOEVE BOERN YOGH HAGELSL | 3 | 1 | Eet |
602972 | JUMBO GEKLEURDE EIEREN 6 | 1 | 1 | Eieren |
198297 | OPTIME DRINK AARDBEI 1L | 6 | 1 | Drink |
It counts how many times certain items are found, so some items are found twice and adds up those qty amounts. Even singular appearances get in this 2nd table. Also, its only for the items with the type "Overcode". I don't need this for the other types only for this. This allows me to find which items are being trashed the most, and which are trashed often.
I also don't care if this is with formulas or power query or macro's. It's my own workbook! I hope this information is enough, if not feel free to ask!
Thanks in advance,
Ramballah
*edit* added a picture for reference, and some items appear like 5-10 times with different amount, in this example it just happened that only a few appeared multiple times with only 1 on the amount column. So the amounts can be 5+7 aswell for example!