Forum Discussion
Excel Formula Help
In K11:
=IF(J11="","",IF(J11<=730,"Treatment Needed",IF(J11<=1460,"Treatment Upcoming","No Treatment Needed")))
I would think that a simple Pivot Table gives you the essential summary.
See the attached
mathetesthank you, this works well. I added the group names as a filter too so the recipient could use it. They wanted the group names in a column next to the people's names, but this solution makes the pivot table look cleaner. I'm personally not a huge fan of the aesthetic of pivot tables, which is why I started trying to figure out formulas, but in the end, it wasn't my product to use and the recipient was thrilled with the product. Credit where it's due, pivot tables are quicker, so thanks much for your help!
I'm glad it worked for your client. I fully understand your aversion to the aesthetic of Pivot Tables. They're great for summarizing data like this, but have their quirks and disadvantages as well. As is usually the case with Excel, there would be other ways to use some of the Dynamic Array functions to produce a comparable result, but they're more complicated so if this works, I'd stick with it.