Last seen: Mar 8, 2026
Hello Amol, Not sure how you get the Please verify result on all rows, as it works just fine for me. Br, Anders
Hello, The error message states that you have duplicate entries in both columns. It also states that at least one of these columns need to have uni...
Hello, Just came to think about your issues with this picture lookup this morning. I did mention in my first post that it is not the pictures you a...
Hello, I don't have Office 2019 so thus don't have the new context menu options as shown in your picture. Did you check the guide I linked to in my...
Hello, As Jessica writes, you need VBA if you want to count by colour, but why bother when you can use the same criterias used in the CF rules and ...
Hello, Regarding the Fan5 issue, it was because I had forgot to name cell B6 to TDF_Image. Works fine after that was fixed. I copied the Images ...
Hello, Without a sample file we can't look for any errors, I mean, if the expected result is 0 and you get those numbers, then there must be some c...
Hello, See attached file for an example. Type in (or paste) the below nested IF formula in cell C3, then drag and copy to the remaining cells. ...
Hello, No picture. Not sure what context menu options you want to get rid off, perhaps this guide can give some help. Br, Anders
Hello Anton, Nearly there, it is not the pictures you are to name, it is the cells where the pictures are that are to be named. See attached file. ...
Hello, As Mynda mentioned almost a year ago, create a table for your criterias. Example table below is called TimeCriterias Start time ...
Hello again, And the online DAX reference pages are found here. Br, Anders
Hello, The PQ functions are very well documented in the Power Query M function reference site found online. Use the information you find there to f...
Hello Lea, Here is an article that gives some help about this topic. As per standard Excel uses the date and time format set in the operating syste...
Hello, See attached file, should work fine as long as I3 is 54 or less. You can tweak it further if needed. Br, Anders