C
cisgalk
Hello everyone,
Hoping someone can help me with this one - it has me stumped.
I have a spreadsheet that has an overall category in row 3, with
subcategories under in rows 4 through 10
In cells B4:B10 are alpha values: "Level 1", "Level 2", or "Level 1&2"
Here is what I would like to appear in cell B3:
If "Level 1&2" appears anywhere in B4:B10, returns "Level 1&2"
If "Level 1" and "Level 2" appear over the range B4:B10, returns "Level 1&2"
If only "Level 1" appears anywhere over range B4:B10, returns "Level 1"
If only "Level 2" appears anywhere over range, returns "Level 2"
Does anyone know a formula that will work for this?
Thanks
Hoping someone can help me with this one - it has me stumped.
I have a spreadsheet that has an overall category in row 3, with
subcategories under in rows 4 through 10
In cells B4:B10 are alpha values: "Level 1", "Level 2", or "Level 1&2"
Here is what I would like to appear in cell B3:
If "Level 1&2" appears anywhere in B4:B10, returns "Level 1&2"
If "Level 1" and "Level 2" appear over the range B4:B10, returns "Level 1&2"
If only "Level 1" appears anywhere over range B4:B10, returns "Level 1"
If only "Level 2" appears anywhere over range, returns "Level 2"
Does anyone know a formula that will work for this?
Thanks