Excel: Category Formula Help


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!

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


This question generated 23 answers. To proceed to the answers, click here.

This thread is current as of October 29, 2013.


For more resources for Microsoft Excel