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 that I want it to show blank in column K when there is no number in column J. Any help and guidance to help me figure this out would be greatly appreciated.
Thank you.
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!
In K11:
=IF(J11="","",IF(J11<=730,"Treatment Needed",IF(J11<=1460,"Treatment Upcoming","No Treatment Needed")))Hi Hans, I am getting a #VALUE! error when I plug that in K11
Here is your workbook with the proposed formula.
