Feb 21 2022 12:53 AM - edited Feb 21 2022 01:19 AM
Hey everyone!
I have issues creating the right excel formel.
- I would like to examine the excel row (B3:R3).
- If there is no "x" in the row, the cell should contain "GameChanger",
- If there is "x" 1-2 times, the cell should contain "Differentiator"
- If there is "x" 3-4 times, the cell should contain "MustHave".
I would be very happy for any help!
Best, Hannah :)
Feb 21 2022 01:17 AM
@Hannah997 That could like this:
=LOOKUP(COUNTIF(B3:R3,"x"),{0,1,3},{"GameChanger","Differentiator","MustHave"})
Feb 21 2022 01:29 AM
Feb 21 2022 01:36 AM
@Hannah997 Perhaps you need to replace the comma's with semi-colons. Are you using English Excel?
Feb 21 2022 01:38 AM - edited Feb 21 2022 01:39 AM
Solution@Hannah997 See attached file. It should "translate" to your local settings automatically.
Feb 21 2022 03:26 AM
Feb 21 2022 01:38 AM - edited Feb 21 2022 01:39 AM
Solution@Hannah997 See attached file. It should "translate" to your local settings automatically.