Last seen: Jun 30, 2026
Hi Blanka, I just checked which courses you took and see that you also did the Power Pivot course. Why don't you use Power Pivot and load both o...
Hi Amy, I've sent you the email with the contact details again. I only got one reply for a consultant in your area. Kind regards, Mynda
Hi Micky, Great to see you having a go, however that formula counts everything except the blank cell. Rathanak wants to also count the special char...
Hi Rathanak, You can use this formula to count all cells that don't contain numbers, it's easier than trying to handle all sorts of special charact...
Hi Robert, I see that somehow the lesson numbers for that course are out by 1. Session 4.10 is actually 3.10. So please refer to session 3 files fo...
Hi Blanka, I wouldn't use a Slicer for this since there'd be (potentially) too many dates. Instead you could use dynamic named ranges to return a r...
Hi Bill, Yes, you can. See example attached. You have to add another table containing the acres for each LOMPOC and then merge those tables toge...
Hi Oleg, If you change your M code for TransactionLY query in the advanced editor to this: let Source = TransactionPathLY, #"Filtered Ro...
Hi Angela, I've not experienced that before. Are you able to share a sample file and your query so I can see if I can reproduce it. Mynda
Hi Oleg, I'm glad it's working now 🙂 I didn't add a step called #"Filtered Rows1" and if you removed it then you need to also change the subse...
Hi Diana, That's odd. I have Excel 2013 and the option is there. Are you able to share the workbook? Mynda
Hi Bill, It looks like you didn't click the 'Start Upload' button after choosing the file you wanted to share. Can you please upload it again. It's...
Hi Susan, I recommend you use a PivotTable to summarise your data, a Pivot Chart to present it and Slicers to control the filtering. This way the P...
Hi Oleg, I can't test your file because you didn't include the files from the folder, but try this: 1. Remove the last step (#Filtered Rows) fro...
Hi David, It may be more efficient to use the PivotTable to extract the data and then use VBA to format the PivotTable as you want, as opposed to u...