Last seen: Mar 8, 2026
Hello, Great that it works as you want. Yes, as your night hours start from midnight and you only have time values it’s enough to check if time is ...
Hello, If you use 00:00 instead of 24:00 you can simplify the formulas, see row 42 for such an example. The cells with blue background colour are t...
Hello, COUNTIFS came with Excel 2007, so it is not working with 2003 version. What you probably could do is to use an array formula using SUMPRODUC...
Hello, Seems that you get an error if D3 = Specific Permit/Facility Documentation, else it should work. Is that correct? What I see you are miss...
Hello, If the numbers are Excel date serial numbers then the dates are: 41729 = 2014-03-31 (March 31, 2014) 42625 = 2016-09-12 (September 12, 20...
Hello, I am writing this while Alan's post is awaiting moderation, so it might be that I give the same answer as he does. In worksheet CPB Doc R...
Hello, Welcome to MOTH. Hyperlinks let you jump to where it is linked to, it is not designed to work the way you describe. Anyway, you can read ...
Hello again, Well, I can't find any explanation to why it behaves like that. Seems that a regular PivotTable is the better option if you want to ha...
Hello, Use LARGE instead of MAX, then you can decide if you want the last, second last or fourth last and so forth. {=INDEX(H:H,LARGE(ROW(H:H)*N...
Hello, Thank you for uploading a sample file. What version of Excel do you use? Do you have access to the new dynamic array functions? If so then t...
Hello, There are good support articles at Microsoft, for example this one about sorting data in PivotTables or -Charts. At the bottom of the page y...
Hello, Can you please upload a sample file so we don't have to spend time trying recreate the file. Br, Anders
Hello, It was just an issue about number format. Excel removes leading zeros in numbers. In attached file you can see how I built the formula. If t...
Hello, No file attached. Try to upload again. Br, Anders
Hello, Yes, it can be done, you do need to wrap with INDIRECT for it to work. =SUMPRODUCT((Invoicing[[Invoice Value]:[Invoice Value]]*INDIRECT("...