Last seen: Mar 8, 2026
Hello, Translations is not really an Excel issue, but anyway. The different translation services on the web says that tanggal awal is start date in...
Hello, Check in the name manager and you should find the names and their references there. You can rename those, the names will be updated in the f...
Hello, If you want you can use pivot tables instead, for that you then need to rearrange the data to a tabular format, see attached file for an exa...
Hello, See attached file for an example on how to get the percantage using an IF statement. Br, Anders
Hello, In some courses the start and end numbers differs, so if those numbers represent the number of students, how would we know which week they e...
Hello Ahmad, What is the expected results? You do get values in return from your formulas, but you write you did not succeed. Br, Anders
Hello, First of all my apologies, I confused the SMALL function with the MIN. You need to use the CHOOSECOLS function to build your array. =SMA...
Hello, I don't really understand your question, but I assume you want to use =SMALL(J:U) but excluding K and P columns, if so then just split it up...
Hello, Once you start working in Power Query and get to know what you can do with it, you will start using it, so I do think you should put some ti...
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...