Forum

Hello, Your data layout in the sheets was not consistent, which is needed. See attached file, I have added a Pivot Table solution also in the Data ...

Hello, Take a look at this blog post. I do recommend to gather all data into one Excel table, as you can then use a Pivot Table to sum the numbers....

Hello, Thanks, I am glad I could give some help. You can read more about ISOWEEKNUM in this blog post. If that does not suit your purpose, for e...

Hello, If I were you I would go with a Pivot Table solution. This reply is not really answering your question, but show an example of how easier it...

Hello, Use this formula to highlight dates two months or more back. =AND(NOT(ISBLANK($E15)),$E15<DATE(YEAR(TODAY()),MONTH(TODAY())-1,DAY(1)))...

Hello, If you change the formula to =AND($E15>TODAY(),$E15>=(TODAY()+30)) it works as you want. Br, Anders

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