S
Sue
I'm looking for a formula to translate 21 different qualifiers in Column A to
one of 3 desired values in Column B. Example, Column A reads: Red, Blue,
Green, White, Yellow, etc. I need a 1 entered into Column B if Column A is
Red or Blue, a 2 entered into Column B if Column A is Green or White, etc.
Any suggestions? Thanks!
one of 3 desired values in Column B. Example, Column A reads: Red, Blue,
Green, White, Yellow, etc. I need a 1 entered into Column B if Column A is
Red or Blue, a 2 entered into Column B if Column A is Green or White, etc.
Any suggestions? Thanks!