Forum

Hello David, It is always better if you also upload a sample file. What Excel version do you have? If you do not have 365 version then you most ...

Hello, Power Query operates on given instructions, so it needs data that identifies what rows to keep. You seem to be able to tell as you describe ...

Hello Craig, In attached file you will see an example of, in my view, a better approach to handle the data. This is just an example aimed to show h...

Thanks Velouria! I learned a new use of SUMPRODUCT. Br, Anders

Hello, Based on your formula, where you check if the dates in column H is less than or equal to the date in cell E21, the result of four is correct...

Hello, This formula works between rows 4 and 227. If you highligt certain part of the formula, for example (ROW()-4) and then press F9 you will ...

Hello, That would be great. There are more than one solution in Excel to get what you want and with VBA you can of course create more. I hope I gav...

Hello, Please see updated attached file. Br, Anders

Hello, I would suggest that you gather the data in a tabular format, as you then can use that data to feed Pivot Tables / dashboards. Gives you lot...

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