Hi all.
A small problem I just can't seem to wrap my head around...
I am trying to create a planner and I've tried countif, Datavalidation and conditional formating but when ever I think I am close no dice.
My challenge is this:
I have X number of people who all have to have lunch together each month but only one on one.
So if Person 1 has lunch with Person 2 they can't have lunch with person 3, 4, 5, and 6 that month.
My sheet would look something like this:
<tbody>
</tbody>
What I need is to somehow check if the same combination exist in the same month?
IE. February where Name 2 & 4 both have a appointment with Name 5.
Like I said I just canøt wrap my head around it..
What gets me everytime is that I need to somehow check if name X is present in Column Month and the value can be either 0, 1 then true and if more than 1 then Error.
There might be a simple solution to this but I just can't see it
Sincerely
Kenneth Andersen
A small problem I just can't seem to wrap my head around...
I am trying to create a planner and I've tried countif, Datavalidation and conditional formating but when ever I think I am close no dice.
My challenge is this:
I have X number of people who all have to have lunch together each month but only one on one.
So if Person 1 has lunch with Person 2 they can't have lunch with person 3, 4, 5, and 6 that month.
My sheet would look something like this:
A | B | C | D | E | |
1 | Name | January | February | March | Etc.. |
2 | Name 1 | Name 2 | |||
3 | Name 2 | Name 5 | |||
4 | Name 3 | Name 1 | |||
5 | Name 4 | Name 3 | |||
6 | Name 5 | Name 4 |
<tbody>
</tbody>
What I need is to somehow check if the same combination exist in the same month?
IE. February where Name 2 & 4 both have a appointment with Name 5.
Like I said I just canøt wrap my head around it..
What gets me everytime is that I need to somehow check if name X is present in Column Month and the value can be either 0, 1 then true and if more than 1 then Error.
There might be a simple solution to this but I just can't see it
Sincerely
Kenneth Andersen