I have two columns in a spreadsheet that I need to restrict the data codes that can be used. Column E takes a code, which would be one of 3 to 6 major categories. Column E would be restricted to only the major codes with no other entries. Column F will take a code which is subordinate to one of the 3 to 6 major codes.
Example: Code SDM (used only in column E) would be a major category code. Subordinate to SDM would be DV, LL, SP, DM, up to 8 codes and only those pre-determined codes.
The Idea is that if a major code (up to 6 with was placed in a cell in column E then only one of its subordinate codes could be placed in column F in the adjacent cell.
Example: Code SDM (used only in column E) would be a major category code. Subordinate to SDM would be DV, LL, SP, DM, up to 8 codes and only those pre-determined codes.
The Idea is that if a major code (up to 6 with was placed in a cell in column E then only one of its subordinate codes could be placed in column F in the adjacent cell.
| Book2 | ||||||
|---|---|---|---|---|---|---|
| E | F | G | H | |||
| 1 | Major | Minor | ||||
| 2 | SDM | SP | ||||
| 3 | EF | RD | ||||
| 4 | Ef | TV | ||||
| 5 | MT | CS | ||||
Sheet1 | ||||||
