Forum

Hello, The problem is not the workbook, as you have mentioned already it works fine, also on my computer (running W10 version 1909, using Excel in ...

Hello, The needed formula in cell Q2 is =(P$3+1)*COLUMNS($B$2:Q$2)-SUM($B$2:P$2) Br, Anders

Hello Frans, No such option if you only are looking at data validation drop down list, but I can imagine that you can build such control with VBA. ...

Hello, If you update one query at the time, you should be able to see which query that is causing this issue. Or are you not able to update any que...

Hello, What does the source data look like? Please attach a sample file, it will make it easier for all of us. Br, Anders

Hello, Here is a short guide on how to insert linked Excel data to PowerPoint. And here is a guide showing how to insert a linked Excel chart. B...

Thanks for the tip Phil! I am now just wondering how on earth I have missed such simple fact during the years I have used Excel. There is always somet...

Hello, Using IFS function is almost as nested IF’s. =IFS(M5<0.4,M6*A3,AND(M5>=0.4,M5<=0.49),M4*B3,AND(M5>=0.5,M5<=0.59),M4*C3,M5&...

Hello, A few suggestions, depending on how the data is coming in to this Excel file. If typed in then it is of course better and easier to type ...

Hello, There are some tools and methods you can use, most of them only looks for exact duplicates. I found a web page here that gives short explana...

Hello, Please have a look at this blog post, it also describes on how you use # character when referencing to spilled data. Br, Anders

Great, I’m just glad I could help. Take care, /Anders

Hello Frans, I have played around a little and by using a helper column I could do one formatting rule that highlights the cells per row that has l...

Hello Frans, See attached file, I have added two new sheets, Sheet2 and data (2). As you can see in sheet data (2) I have adjusted the data to b...

Hello, As Purfleet hints, you should go for a VBA solution to calculate the sales price, the result should be put in the sheet as numbers. In such ...