Forum

Hello, Sorry, here comes the updated copy. Br, Anders

Hello, With the help by Hans’s and Riny’s comments I did some changes and now got the wanted result. Hopefully it works with the real data too. ...

Hello, I am not sure I understod this correct, I have followed the instructions but am far off from your wanted value. Do check if this is usable o...

Hello, You can use =SUM(COUNTIF(A1:A17,B1:B17)) to sum the duplicates found in column B. Br, Anders

Hello, In your sample data you have no T1 discount factor below 12, that is why you get the #DIV/0! error. You can use IF or IFERROR to handle such...

Hello, Check out the blog article Dynamic Dependent Data Validation to see one way to get what you want. If you need hands on help, please uploade ...

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...