Oh i didn't know power query could be refreshed this quickly on such a sheet (i know very little about power query, the tutorial i tried didn't vibe with my version of excel). Very good tutorial as always! I set up a report that finds duplicate orders for my colleagues, so they have a lot less hassle with unhappy customers now. I created a report that goes through our open orders and finds duplicate order numbers. If this happens, i get an alert, and an email. It rans constantly on a spare pc, and about once a day there is something wrong. And if there is something wrong, i find out very quickly and we don't ship the stuff. It works with countif i think. My colleagues think I'm some kind of all knowing genius 😂 and it just runs by itself.
Wow, that sounds amazing!! I love it when a spreadsheet “just runs by itself” 🥳. If you have any other spreadsheets that need work, I have an awesome masterclass here: www.excelpowerup.com/training
I was the first student to arrive to study and felt very happy.
Oh i didn't know power query could be refreshed this quickly on such a sheet (i know very little about power query, the tutorial i tried didn't vibe with my version of excel).
Very good tutorial as always!
I set up a report that finds duplicate orders for my colleagues, so they have a lot less hassle with unhappy customers now.
I created a report that goes through our open orders and finds duplicate order numbers. If this happens, i get an alert, and an email. It rans constantly on a spare pc, and about once a day there is something wrong. And if there is something wrong, i find out very quickly and we don't ship the stuff. It works with countif i think. My colleagues think I'm some kind of all knowing genius 😂 and it just runs by itself.
Wow, that sounds amazing!! I love it when a spreadsheet “just runs by itself” 🥳. If you have any other spreadsheets that need work, I have an awesome masterclass here: www.excelpowerup.com/training