Last seen: Jun 2, 2025
Hello, Please upload a sample file with your data. The numbers in your picture says one thing, what you write another. If the sell price for 1 l...
Hello, Seems to me that every order with a created date but no shipped date is to be summed, which should be doable to setup. If you can upload a s...
Hello, You can use XLOOKUP with logical criteria for this scenario, see attached file for an example. =XLOOKUP(1,(lookup_value1=lookup_array1)*(...
Hello Kevin, Unfortunatly, the file upload did not go through. Seems you might have forgot to click the start upload button after you added the fil...
Hello, I took this as an oppurtunity to test myself if I remembered how to twist the functions like in the old days. I would choose the pivot table...
Hello, You need to update the pivot table after any changes made in the source table, just right click in the pivot and choose update. You can read...
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...