Last seen: Sep 18, 2025
@stephanrs Assuming that your problem lies in your comment "... to workaround the 24H HOUR MAX limitations of XL Dates/Times as conventional TIME (H...
@lanser No need to upload over a hundred files. Can you recreate the error with only two or three?
@kasey In H3 and copied down, try this: =ROUND( MAX( 0, MIN( B3, $E$3 - SUM($B$2:B3) + B3 ...
Difficult to know without seeing your files. Could you share them? And what do you mean when you write "what does the 142 refer to" ? In the botto...
@old-nuke I believe you can use CHOOSECOLS as demonstrated in the attached file.
@robert-forest You need a weighted average, rather than a regular average. So, multiply each response time by its frequency and divide the sum by th...
@kasey Oh sorry! I though that was obvious. Close the other file, work on the query(ies), Refresh and the error will not occur.
@kasey When you connect PQ to data in another file, that other file may not be open when you edit/refresh the queries that connect to that file. You...
@erik_h_dk Glad I could help. As mentioned before, it's not difficult in PQ either. So, if you prefer using PQ, please see the attached file.
@erik_h_dk Must you do this in PQ? Quite easy to do it in Excel. Have a look at the attached. Not very difficult to replicate this in PQ as well. ...
Your xlsm file contains several macro's that do fuzzy matching in different ways. Aren't these working for you? Personally, I'm not a big fan of VBA a...
@blackvan I noticed from posts about a year ago, that you were using Excel2010. The attached solution won't work if that is still the case, but I h...
@nicka The attached file contains a small example of a conditional format that you describe. See if you can replicate it with your real data. Even t...
@marvo Let's not give up. See attached and good luck!
@marvo Wait a minute!! your test file doesn't have any real scores, so the cut-off points become -6 and that is not very meaningful. The origin...