| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Is the data validation criteria limited to a few number of items .
I would like to have several list in a particular cell. However, I have found
that Excel is limited to the number of items that can go in a list. Why? Or how can I list a choice of 30 or more items in one cell? |
|
#2
|
|||
|
|||
|
Rhonda
I just put 3000+ numbers in a list and selected it as the validation source. No problem. What does your data look like ? Regards Trevor "Rhonda Pugh" <Rhonda wrote in message ... I would like to have several list in a particular cell. However, I have found that Excel is limited to the number of items that can go in a list. Why? Or how can I list a choice of 30 or more items in one cell? |
|
#3
|
|||
|
|||
|
The date are words. IE... Loans, Home Equity, Personal Unsecured .....
"Trevor Shuttleworth" wrote: Rhonda I just put 3000+ numbers in a list and selected it as the validation source. No problem. What does your data look like ? Regards Trevor "Rhonda Pugh" <Rhonda wrote in message ... I would like to have several list in a particular cell. However, I have found that Excel is limited to the number of items that can go in a list. Why? Or how can I list a choice of 30 or more items in one cell? |
|
#4
|
|||
|
|||
|
Rhonda
I can't see why it should be a problem if you do as Debra described. That's the way I tested using just numbers Regards Trevor "Rhonda Pugh" wrote in message ... The date are words. IE... Loans, Home Equity, Personal Unsecured ..... "Trevor Shuttleworth" wrote: Rhonda I just put 3000+ numbers in a list and selected it as the validation source. No problem. What does your data look like ? Regards Trevor "Rhonda Pugh" <Rhonda wrote in message ... I would like to have several list in a particular cell. However, I have found that Excel is limited to the number of items that can go in a list. Why? Or how can I list a choice of 30 or more items in one cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data validation, cell protection or other method? | Excel Discussion (Misc queries) | |||
| DATA VALIDATION IN REVERSE #2 (FOR JULIE D.) | Excel Discussion (Misc queries) | |||
| SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
| Effect of Conditional Formatting, Data Validation | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
