Excel 2010
Is there a way to build a formula for E4, F4, E5, and F5?
My data is going to be in columns A, B, C. Is there a formula that would categorize the data into E and F? Please let me know! Thanks in advance!
<tbody>
</tbody>
Is there a way to build a formula for E4, F4, E5, and F5?
My data is going to be in columns A, B, C. Is there a formula that would categorize the data into E and F? Please let me know! Thanks in advance!
A | B | C | D | E | F | G | |
1 | |||||||
2 | |||||||
3 | ID number | Options | Category | ||||
4 | 100 | 5x7 | Rugs | Rugs | 3 | ||
5 | 100 | 5x8 | Rugs | Bed | 2 | ||
6 | 100 | 5x9 | Rugs | ||||
7 | 200 | 5x7 | Rugs | ||||
8 | 200 | 5x8 | Rugs | ||||
9 | 200 | 5x9 | Rugs | ||||
10 | 300 | 5x7 | Rugs | ||||
11 | 300 | 5x8 | Rugs | ||||
12 | 300 | 5x9 | Rugs | ||||
13 | 400 | Queen | Bed | ||||
14 | 400 | King | Bed | ||||
15 | 400 | Twin | Bed | ||||
16 | 500 | Full | Bed | ||||
17 | 500 | King | Bed | ||||
18 | |||||||
29 |
<tbody>
</tbody>
Last edited: