Last seen: Jun 25, 2026
@cbird Have you by any chance watched Mynda's recent video on P&L dashboards (link below)? The technique you need is very well described in it...
@cbird Your pivot table is in 'Compact Form'. On the 'Design' ribbon, choose the 'Tabular Form' report lay-out as shown below. (Screens...
@navsal66 Thanks for clarifying. I believe you need the following formula in I2 and copy it down. =IF(ISNUMBER(SEARCH(G2,B2)),"YES","NO")
@navsal66 You have lost me. Two tables with similar "Name" and "CJ description" that need to be matched somehow. And you want to return something in S...
@navsal66 Still not sure if I fully understand but in the attached file I used PQ Fuzzy Matching to merge the two tables based on the description colu...
@navsal66 Can you share your updated file again please?
@navsal66 That's going to be difficult. You have the word Inch and the character " and in reversed order with MM and mm. Excel doesn't know that " ...
@dp Not really sure what CHAR(29) is supposed to be doing but it shows as a small rectangle within the texts. I just copied the character and then ...
@softballrick See if the attached filed contains a working solution for you. You'll need some DAX measures and play around a bit with the format of...
@cbird I've added a working DSUM formula to your worksheet in Q14, but wonder why you insist on using it. Please note that the database needs to refer...
@markelliott Not sure without seeing the file and/or query. Did you perhaps save that file as CSV as well? You should have seen a warning that you c...
@zedbeeble OK, but just to be sure we are on the same wave-length. Exactly which template are you working off?
@zedbeeble Difficult to say without seeing the file. Would you be able to share it here? Just remove any private and confidential information, but l...
@dchamlinii Not sure which tracker you are referring to, but I assume it's Mynda's "Personal Budget" template. All tables in that file are structu...
@ads And you are sure that the process of creating the PDFs and/or their origin has not changed?