Forum

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

Hello, Can you give examples of what data you want in the yellow rows, I do not understand what it is you are trying to do. Br, Anders

Hello, With signature line you can’t sign an individual sheet, you sign the workbook. Br, Anders

Hello, Not sure if the text to speech feature works for this, you have to try it out. Br, Anders

Hello Peter, As I don't know what version of Excel you are using, but see if you can use XLOOKUP function instead. Br, Anders

Hello Carl, You have made the date as text. Try below formula. I pretend in this example that the date 200104 is in cell Q25. =DATUM(20&VÄNSTER...

Hello, The column header Duration most likely interferes with the Excel function Duration, just rename the header. Br, Anders

Nice job Velouria!

Hello John, So you don't want a parameter based solution then. As far as I understand what you want to do, you are most likely better off with a...

Hello John, Just change the formula in cell O4 to =IF(ROW(INDIRECT($R$2))=ROW(),Result,""). Make sure it copies down to the other cells in the tabl...