| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATA VALIDATION LISTING UNIQUES
I have a column reflecting branches & cases as follows:
CASE1 BRANCH1 CASE2 BRANCH1 CASE3 BRANCH2 CASE4 BRANCH2 CASE5 BRANCH3 What is required is a Data Validation List Type of check on C1 which shall display only a unique list of three branches instead of 5 entries. Furthermore, when a branch like Branch2 is selected only the respective cases's list i.e. Cases3 & Case4 is available in D1. Thanx -- Best Regards, FARAZ A. QURESHI |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| pulling data from one sheet and listing selected data in another | Excel Worksheet Functions | |||
| listing and selecting data | Excel Worksheet Functions | |||
| Listing a selection of data from one worksheet on another | Excel Discussion (Misc queries) | |||
| Listing data | Excel Discussion (Misc queries) | |||
| selecting and listing data | Excel Worksheet Functions | |||
Threaded Mode
