Last seen: Jun 25, 2026
@pjward I would create a vendor table as demonstrated in the attached file. Start with the vendors and account numbers you want to 'attach' to the i...
@pjward May I suggest that you upload your example spreadsheet, in stead of a PDF. Much easier to work with data in an Excel file.
@prof_fr Good luck! If you get stuck, come back here.
OK, so you have one query that combines all files from the Data folder. What are the other 79 queries doing?
@prof_fr You write "from one data file which contains 156 Excel files". Do you mean one file with data that originates from 156 other files? If so, ...
@phil1961 Cell A3 contains "Chase " (note the trailing space!). SUMIF is looking for "Chase" and thus skips the value for "Chase ". Remove the spac...
@stockjam It's difficult to determine the cause of this based on a picture in a PDF only. Can you share the XLSX file, like I did earlier? Just for...
@vik Well, I would collect all data in a tabular format. For instance, a five column table with the following headers: Project, Object, Date, Amount...
@vik I believe that your set-up make matters unnecessarily complicated, but that's your choice. The attached file has the formulas that calculate th...
@vik Not sure without seeing what exactly is in the cells you reference but your original formula doesn't seem to make sense. Perhaps this one does ...
@phil1961 The template you are using (Mynda's) has rectangle shapes that contain the references to individual cells inside pivot tables. Such shapes...
@phil1961 Don't really know! Inserted the split screen again and can still insert a row where I want. Would need a step-by-step guide on what you did ...
@phil1961 Removed the screen split and the filter on the table. You have 460 empty rows in there. Removed them as well and can insert a row anywhere I...
@stockjam Attached workbook contains one way to deal with it. The query is quite crude but works for a relatively straight-forward task like yours. ...
@navsal66 OK, being new to PQ is somewhat of a challenge. All the steps are listed in the “Applied steps” list. Most are done by clicking in the User ...