This video is a little different than the rest. Someone needed help and I came up with 2 solutions–both shown in this video. What’s more important about this is the discussion about the hard solution vs. the concise solution. Sometimes the hard solution serves us better because we understand it. The concise solution may look […]
A friend contacted me and asked how Excel might help calculate points for what he described as a “buddy system” where he goes to the gym. Here’s the challenge: – Marvin and Drew are paired in this buddy system – If one attends a class, the team gets 1 point. – If both attend together, […]
COUNTA is an unsung hero. It’s not likely to show up on anyone’s Top 10 Excel functions or features. Yet, COUNTA does a lot! In this video I show multiple ways that COUNTA continues to be a favorite of mine–even with the glamorous features like XLOOKUP, Power Query, Dynamic Arrays, etc. You’ll see: – COUNTA […]
One way to get good at Excel is to find multiple ways to solve a problem. In this video I look at a recent problem where I pasted data into Excel from a website. The data ended up in a tall stack, and what I needed was buried in the mix. I immediately thought of […]
Mr. Excel, Bill Jelen, was presented with a challenge where someone’s data was twisted in a weird sort of way and needed to be untwisted; e.g. the data needed to be flattened. Here is the challenge: https://youtu.be/S9ow-1Jq_rE Bill asked for other solutions than his own. Here’s mine. This is one of those examples where it […]
In the previous video I showed a solution to a problem presented by Alan Murray at ComputerGaga. But Haider Ali asked about missing entries. (To purchase Excel Insights, here it is: https://www.mrexcel.com/store/index.php?l=product_detail&p=381) The challenge requires data to be converted from jumbled lists and into neat rows. The lists are what people have chosen for an […]
Alam Murray at ComputerGaga postd a challenge that someone had asked him to help with. https://www.linkedin.com/posts/alanmurray-computergaga_excel-powerquery-activity-6621158742408867840-lhby Data containing meal selections came in looking like rosters, and weren’t helpful to anyone. So, the data needed to be converted 2 ways. – A count of requests for each offered meal – Each person on a row with […]
In the previous video I showed how to reconcile Christmas payments between 3 siblings. It seemed that classic Excel using SUMIFS was a better solution that Power Query. However, after posting the video, Miguel Escobar offered a simple Power Query solution. But it’s tricky. It involves merging a table with itself and criss-crossing the fields. […]
This video revisits a challenge from a few years ago. 3 siblings needed a simple way to reconcile who owed what to whom after all the Christmas gits had been purchased. For example: If Bo agreed to chip in $200 on gifts that Jay bought, and Jay agreed to chip in $90 on gifts purchased […]