Forum

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

Hello, In my opinion you should go for a non formula solution, makes things far more easier. In attached file I have added three sheets, Pivot, PQ ...

Hello, See if Mynda’s blog about Linear Regression gives you any help in this. Br, Anders

Hello, I find it difficult to follow the logic here, you want to sum something overdue in P column. How do you know if it is overdue when there are...

Hello, This issue is similar to what can happen on a computer also. Go to View and untick to show the grid lines. Does it behave the same when you ...

Hello, Can’t really explain why it behaves like this, but if you round the calculation in column G you get correct result back from your lookup. Bu...

Hello, This is a math excercise. What is 1% of 14800 = 14800 / 100 = 148 What is 0.25% of 148 = 148 * 0.25% = 0.37 How many 0.37 can you h...

Hello, Same happens to me in Excel on iPad.

Hello, Easiest method to reverse calculate percentage is value / percentage * 100. 1.48 / 4 * 100 = 37 37 / 0.25 * 100 = 14 800 Br, Anders

Hello, Just restructure your lookup tables and then it's just ordinary VLOOKUP to get what you want. See attached copy of your file. Br, Anders