Forum Discussion
Solved
Excel Formula Help
Hey everyone, I am looking for a fix to my formula. Its probably something simple that I am just not seeing but in the attached sheet in Column K I have a formula. It is working with the exception ...
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
mathetes thank you, this works well. The recipient wanted the group names in a column after the people's names, so I added the group names as a filter so the recipient could refine the data as needed. I'm personally not a huge fan of the aesthetic of pivot tables, which is why I started trying to figure out formulas, but the filters made the pivot table look cleaner. Credit where it's due, pivot tables are quick, so I appreciate the help!