Forum

Hello, I followed the written instructions about the same. The error you made is that you named the pictures and not the cells where the pictur...

Hello, As Purfleet writes, please add a workbook instead of picture. The only reason why you get #N/A as a result of your VLOOKUP formula is becaus...

Hello Frans, Perhaps this post can guide you further on. Br, Anders

Hello, Please give more information of what it is you are looking for and what the expected result should be. As it is now I can only guess what is...

Hello, I agree with Phil, it is better not to distort the measurements. The blood pressure reading is one thing and the salt intake is another. ...

Hello, Add a new custom formatting rule (no background colour) with following formula: =ISNUMBER($K3) Put this new rule as the second rule. For thi...

Great, glad I could give some help.

Hello Deepak, In order to keep things simple I have added a helper column as a base to count unique TEU per SB NO. See attached file (a modified co...

Hello, I know you already got a sufficient answer, just want to add that you can use an array formula with SUM to get what you want. More about arr...

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