Last seen: Mar 8, 2026
Hello Tango, This blog article gives a good description of how to get the 1st or 3rd (and so forth) weekday of a month, check it out. I can't fi...
Hello, Please attach an Excel file instead of pictures, your formulas are referencing columns we don't see in the pictures and not many want to sit...
Hello, As you want it to be dynamic it is easiest to make the calendar in a pivot table, as shown in the attached copy. If you want to have two se...
Hello, See attached file for one way to solve this. As your dates are numbers it makes it easier to sum the values per month. In short I am usin...
Hello, See attached file for a solution. I used COUNTIF to count the occurences of a value. Br, Anders
Hello, You should be able to get what you want with the SUMIF function. What you need to work with is how to check what month the transaction dates...
Hello, Just add the date with the time. =SUMPRODUCT( ([@[Dates]]+[@[Start Time]]<FILTER([Dates]+[End Time];[Meeting Room]=[@[Meeting Room]]))...
Hello, You can use LOOKUP for this. In H5, enter following formula: =LOOKUP(2,1/ISNUMBER(D3:L3),D3:L3) Br, Anders
Hello, No file attached. Br, Anders
Hello, As Jessica writes, we can only guess as there can be different scenarios behind this message, just search, One of the scenarios is that ther...
Hello, One way to solve this is if you reference the task name instead of the id number, as the task name remains the same. To avoid typing the tas...
Hello, The simplest solution would be using a Pivot Table. Br, Anders
Hello, If you don’t already have, do a file copy of file A as a backup just in case. Open file A and save a new copy using Save As. Rename file ...
Hello, If there is only one drop down list then you can try using a PivotTable and its filter field, as described in the blog post searchable drop ...
Hello Mesa, Please see the attached modified copy of your sample file, hopefully I have added some useful tips on how to solve your problem. Whe...