Assign values based on scenarios

Lena318 Registered Posts: 1 ✭✭✭✭


Following situation: I have ten columns (two for each weekday). For every weekday I have the information of an absolute and a relative number.

What I want to do: Assign the weekday based on the highest relative number for each row. But if there are two or more columns with the same relative number, assign the weekday with the highest absolute number. If this is also equal for two or more columns, pick one of those days randomly.

I know that I can cover the first condition with an if-formula but have no clue how to incorporate the second condition.

Thanks for your help!

Best Answer

Setup Info
      Help me…