Forum

Hello, Welcome to MOTH. If you upload a sample file I am pretty sure someone can help you out. Would also be good if you in the sample file also...

Hello Saliha, I see no formula in column E, what have you tried with? Where do you get stuck? Condition 1 - You can use SUMPRODUCT to sum the ma...

Hello, Not sure I really understand what you are asking, when checking your latest uploaded file from post no:4 I don't see any errors/issues. Woul...

Hello Dave, Seems the file didn’t get uploaded. After adding the file you need to click on Start upload button and then wait a few seconds. Br, ...

Hello, Do you have a sample file you can upload? Br, Anders

Hello, Can you add a sample with some dummy data so we can see how the data is structured and what the limitations are? Makes it much easier to hop...

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...