Last seen: Aug 18, 2025
@j8150outlook-com Difficult to say without seeing (at least) the query and a screenshot of the folder with the 25 files in it. Make sure that the fi...
@mwahaab Sorry for being slow in understanding. In the attached file I added/changed som columns/formulas (C, D and E) that result in the Variance ...
@mwahaab In your example, the total budget is higher than the Annual Cost. So it could be relatively easy to allocate the minimum of Cost and Budget...
@benjamip You don't show the context in which you apply the formula. Though, two matters come to mind: 1) You index a range from row 5 to 53, but ...
@jessica5 Sorry! I was confused. I now could download the file without logging in. See attached. I first manually correct the order of Subj...
@jessica5 I could not get into you file without asking permissions. You should be able to upload it with your message to the forum also. Anyhow, thi...
@senlo I would really need to see your file but don't understand why you can't upload a file. A regular xlsx workbook should work. I'm attaching one...
@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...