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'm also looking for help with an Excel formula. Sorry I've tagged on to this thread, but I couldn't figure out how to create a new one and didn't find what I needed by searching.
I have two Sheets in an Excel (365) workbook. Sheet2 tab has the data I've pulled (4500 rows of data): Column A = Names (names changed), Column B = Individual ID, Column C = Occurrence Date, and Column D = Group Name. Each name appears on multiple rows with the various dates they attended an event.
On Sheet1, I reduced the data down to 1200 rows. Each unique person on Sheet2 is only on one row of Sheet1 and then the possible range of dates from Sheet2 goes across columns on Sheet1. Sheet1 is set up as: Full Name (Column A), Individual ID (Column B), Group Name (Column C), and then in Columns D thru R I've spread the unique dates horizontally across columns.
My goal on Sheet1 is to have a formula that shows when each person showed up to an event by marking an "X" across their row in any date column they attended and leaving blank any date in that row they did not attend.
I've attached a condensed example of the workbook I'm using. I manually filled in the first row how I'd like the results of the formula to look.
Any help with a formula is much appreciated! Thanks!
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!
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.