Text populated based on multiple cells

[djthery]

Hello,

Looking for some help on figuring out how to make column I populate text based on data entered into column J-L.

I would like Column I to populate UW, UWS, or None either by itself or in a combination based on which cells in Column J-L are marked with "x".

Any help is appreciated! I've been on the google for a while trying to find a formula that would work and haven't found anything yet.

 

[djthery]

Do you have either the Unique function or the Sequence function?

no, those are not available.

 

[Fluff]

In that case you will need to confirm the formula with Ctrl Shift Enter, rather than just Enter.