I am wondering if there is a basic function that will chose the correct section.
I am looking all for one formula so I can apply it for all cells.
Here is a example
What ever is a,b or c, the result will be 1
what ever is d,e, or f, the result will be 2
<tbody>
</tbody>
This is what it should be, I will have about 4 results. I just need to know the formula and i can plug it in.
Thank you
I am looking all for one formula so I can apply it for all cells.
Here is a example
What ever is a,b or c, the result will be 1
what ever is d,e, or f, the result will be 2
a | 1 |
f | 2 |
d | 2 |
b | 1 |
c | 1 |
e | 2 |
<tbody>
</tbody>
This is what it should be, I will have about 4 results. I just need to know the formula and i can plug it in.
Thank you