Display Multiple Results in a single cell?

[Acetaminophen]

Hi All,

I am using excel as a scheduling program. The sheet has days of the month across the top, and staff names down the column. We have 5 shifts D,A,B,C,N. I am using the following formula to display if shifts have been scheduled for the column

if(countifB10:N23,"N")=1,"X","N") i.e for the night shift. I then use conditional formatting to change the cell to green if the night shift has been scheduled, or red if it has not.

I would like to have the results of all 5 formulas display in a single cell, to save Real Estate, then have the cell go green when all shifts have been scheduled for the day (column).

Is this even possible?

Thanks in advance.

 

[Smitty]

Welcome to the Board!

I would like to have the results of all 5 formulas display in a single cell, to save Real Estate

With 16,000 columns you wouldn't be saving anything. If anything you make it more difficult to do what you want. You can easily put the information in separate cells (the way it should be), then develop your formula off of the individual columns, and hide the reference columns, leaving just your total.

HTH,

 

[Acetaminophen]

Thanks Smitty. I definitely see your point.

We have several cells below our 'month' that are indicators for things like too many requests, duplicates, holidays etc, so it does get kind of busy down there. it just seemed like adding 5 more cells deep would make it more chaotic rather than help improve our efficiency while scheduling (manually inputting the shifts for people around their requests).

I thought that ideally we would glance at a single cell that 'X'd' out the shifts as we scheduled them into the column, and turned green when all was scheduled for the day. It sounds like there is no easy solution, and actually what we have will work. We can just hide the cells when we're done with the month.

Thanks for the input!

 

[Smitty]

If you post an example (see the link in my sig for how) we should be able to get you what you need.