hi,
I need the cells to do the following:
If A1="Southwest", 1
If A1="Northwest", 2
If A1="East Coast", 3
There are over 2000 rows, and each cell falls into the three regions above. Do you know how to modify a boolean function to do what I want above?
Thanks!
I need the cells to do the following:
If A1="Southwest", 1
If A1="Northwest", 2
If A1="East Coast", 3
There are over 2000 rows, and each cell falls into the three regions above. Do you know how to modify a boolean function to do what I want above?
Thanks!