Forum

Hello, The closest you get (as far as I know) is to use CTRL + [ to go to precedent cell or CTRL + ] for dependent cell. The shortcuts are for thos...

Hello, The numbers in F and G columns are just decimal numbers, not treated as time. Replace the comma with a colon and you will get the time value...

Hello, See if attached file works for you, using INDEX, SORT, SEQUENCE and FILTER functions. I haven’t checked for tie amount values, might need ad...

Hello, Unfortunately, no file attached. Br, Anders

Hello, I would use Power Query to combine the data, but only so if it is a recurring task. There are lots of tips and guides in the blog section. I...

Hello, You do probably have the advanced setting set to show a 0 (zero) for null values. If not, please share your file (do remove sensitive dat...

Hello, I assume you have Excel 365 and thus MAXIFS function. Try with following formula: =MAXIFS([Status],[Exercise],"*"&[@Exercise]&"*",[N...

Hello, You can skip the IF function, go with =AND(H9<TODAY(),I9<>”Completed”) Br, Anders

Hello, You will find the answers in Microsoft support page Get started with Python in Excel. In the How to use Python in Excel natively blog post y...

Hello Robert, You didn’t complete the formula correct. Check out the blog post for this. In the attached file I have partially corrected your fo...

Hello, Check if this info at Microsoft Learn is of help. Br, Anders

Hello, Just want to point out that you can set up a data table in a tabular format, so regardless if there is only one or several categories, you j...

Hello Peter, I am assuming you mean the Help in Excel, also assuming you are using Microsoft 365. Check if this post gives any solution for your is...

Hello, Managing a risk register in Excel is not the same as using a system specifically designed for the task, it will always be limited and simple...

Hello, There is no need for complex formulas if you just rearrange the data. A Pivot Table would be my choice. Br, Anders