Last seen: Mar 8, 2026
@navsal66 Hello, Sorry, I assumed you wanted each cell to have a max of 12, I most likely misunderstood the second criteria text. 2. These det...
@navsal66 Hello, I am using the LET function in this solution, see attached file.Hopefully it works as you want it to. Br,Anders
Hello, Try with following example: =XLOOKUP(TRUE,(CatgTbl[Keyword]=[@Description]),CatgTbl[Sub-Category],"Uncategorised") As long you keep the k...
Hello, I assume the referenced calendar is Excel Calendar Template Date Formulas Explained. Even though this Automated Work Schedule in Excel cale...
@sari-becker, yes, there is a second XLOOKUP inside the first, will try to explain what the formula does. The formula used here is from cell C10 in yo...
In case you want to use a formula solution you can check the example in the attached copy of your file. Just using the XLOOKUP function.
I forgot to change the semicolon in the formula above to comma. If you check the formula in the attached file it will show up correct. So, do not co...
Hello, I am not sure if I picked the same Automated Work Schedule as you refer too, but it should work as a sample if not. I also assume you are usi...
Hello, It seems you managed to solve your issue and that you found out that you as user has edit rights in HKCU section in the registry. Br,Anders
@knutjdahl Check Mynda's blog article Use Excel Slicer Selection in Formulas. Br,Anders
@kcrett Where do you get stuck? I don't see any of those different options you mention. Below example is one way to sum per the criteria. There ar...
@solarheater It is not clear to me what it is you want and where you want it, also it is not stated what Excel version you work with. It differs bet...
Hello, Thanks for the file, it seems you just have an extra ending space at the end of Admin in B14. When removing that space I get a sum of 12. B...
Hello, Please share the .xlsx file instead as the .csv file is not of much help. Br,Anders
Hello, To me it seems that Power Automate is the tool for you, have you checked it out? Br,Anders