Last seen: Aug 24, 2025
Try right-clicking on the file and "Download linked file as...".
Difficult to diagnose the problem without seeing the CSV file. Could you upload one that contains April 2023 data? When you open the CSV file in a tex...
Don't think you can do that as there is no way that I know of that can combine a regular Excel table with a PQ table. You need to connect PQ to the "r...
Could you please elaborate on what exactly you want to achieve? Upload a file with an example, perhaps.
You wrote: "The blank line is there to make it easier to read while I am walking around trying to contact individuals. " If you want more white ...
The file attachment didn't come through. Please try again and this time don't forget to press the 'Start Upload' button and wait until it's finished b...
Could you please upload a file with example data (replace any confidential information with fake data). Then we don't have to guess how exactly your t...
I agree with Charles but would add that you probably need to wrap the helper for the street number in a VALUE function. Otherwise the 'numbers' will b...
The image you intended to upload doesn't show, but I guess that you added the duration column by selecting the Hold and Start columns and then 'Subtra...
I would suggest that you create pivot table. The attached file contains a small scale example, but it would work just as good on 7000 rows of data.
Hi Keith, Difficult to say why a PQ doesn't connect well to a PDF without seeing the file. But, as an accountant I wonder why your clients provide ...
Thanks for the file. That helps 🙂 No apologies needed! But now, please can you give some examples of the expected results. I'm not 100% sure that ...
Hi, You could try something like this in N3: =INDEX(A:A,MAX((F8:F1000="Review")*ROW(8:1000))) In this example I've limited the range to look ...
This is very odd. I've never come across the issue that a CF rule is accepted on the PC but not on the Mac. I can't find anything about size limits fo...
I tested the first two formulas in the worksheet and didn't get the missing parenthesis error. Though, the 'Completed' formula has a few typo's in it....