Last seen: Apr 19, 2025
Hi Bax, I used to do this exact task in my previous life as a management accountant. I'm pretty sure I demo a technique you can use to do this in l...
Hi Jim, Not using the new picture in cell feature. With this you can store a picture in a cell, but not also store text over the top. The only o...
Hi Hans, In column H add a heading for 'Category' in cell H15. In cell H16 enter this formula: =XLOOKUP([@[Sub-category]],TblCategories[Sub-cate...
Yes, you can just change the number format to whatever you prefer.
Hi Sam, You should use Power Query to import the data and then you can use the 'Change Type > Using Locale' menu to correct the date format. ...
Hi Dennis, The reason you're getting that error is because your formula is incorrect. Please see this tutorial on how to write an IF formula. If...
Hi Sheela, It doesn't appear so. This page uses JavaScript to serve up dynamic results. Power Query can't see this. You can tell it's serving up re...
Hi Sean, Cell formats are not the same as the data type being a date. You can format a cell containing text as a currency, but it will still displa...
Hi Sheela, Please see file attached. You need to merge the tables, then add a conditional column and then Pivot the License Name column. Note: t...
Hi Sheela, Websites like this are difficult to scrape data from because they use JavaScript to serve up the data. You can tell this is the case bec...
Hi Mac, I don't see how this will work when you sell some of the stocks and have those sale entries in your ledger. I thought you'd want to reduce ...
Hi Lili, If you clear the slicer selections, then apply your formatting, they should stick. No need to create a duplicate of your PivotTable etc. a...
Ah, in that case, you can use your new table to lookup the missing names and bring them into your query with the other staff data.
Hi Mac, If you want to track separate purchases and sales of the same stock, you'd need to add a column to your ledger that tags the stock purchase...
If you mean the button says '(blank)' or it's literally a button with nothing on it, then this means you have blank cells in the column your Slicer is...