Forum

Hello, One should perhaps test the tips to see if they work as intended. Turns out the F4 / CTRL + Y keyboard shortcuts is for commands, for exampl...

Hello, Type in the start date, go to next cell and press the F4 key to repeat the previous entry. If F4 does not work, press CTRL + Y instead. ...

Hello, Well, if you are using an old version of Excel it might be that Power Query is not the right tool. Attached is a variant where I use a help...

Hello, You didn't complete all the steps in Power Query. See attached file for the finished version. There are two dates in column A that also exi...

Hello, Take a look at the Excel compare two lists blog post, it describes how to use Power Query to compare two lists. Br, Anders

Hello, The result you want is not per the Broadcasting Calendar system, but never mind, Hans has provided you with a VBA solution and here is anoth...

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