Forum

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

Ooops, I didn't notice the issue on rows 1 and 2. That's a difficult one to automate, though.

Check out Phil's blog post on fuzzy matching in Power query. I believe that it will guide to the solution you need.

Please have a look and let me know the attached file including a query does what you need. I'm insecure about what I highlighted in red on row 26. Is ...

It would be helpful if you could upload a slightly bigger file with more examples of what you are dealing with and indicating how the end result shoul...

There is no attachment. Please try again and don't forget to press "Start upload" before you submit your reply.

Could you please share a file with some example data. How it looks like and how you would like the pivot table to look like.

Please upload a file with some example data but keep the table structure exactly as it is in real life.

Great and don't worry. I won't tell her.

You could, for instance, create a line chart plotting, let's say, temperature on the primary vertical axis and humidity on the secondary vertical axis...

I can't open the xlsx file. Please try uploading it again.

Thanks for sharing!

Your rules calculate the difference between two absolute cell references ($O$2-$G$3). If this happens to be larger than 365, all cells in the range $G...

I am afraid I'll have to leave it to someone else.

Can you upload a file with some example data and the expected result. It's difficult to visualise what you need.