sujittalukde
Well-known Member
- Joined
- Jun 2, 2007
- Messages
- 520
I am using col A as the source list for Data validation list. In col A some items repeat more than once. The problem is that the list also shows the items as appearing in the col A ie if item "A" is appearing for more than once, in the list also it is appearing more than once.
I want that the list should not show an item more than once.
How this can be done?
A snapshot is given below:
I want that the list should not show an item more than once.
How this can be done?
A snapshot is given below:
Book4 | ||||||
---|---|---|---|---|---|---|
A | B | C | D | |||
1 | A | Select at C1 | A | |||
2 | B | |||||
3 | C | Name = mylist | ||||
4 | A | Name range formula | ||||
5 | C | =OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A)) | ||||
6 | D | |||||
7 | F | Problem: Cell A1 is the data\validation\list | ||||
8 | B | Source: mylist | ||||
9 | E | The list at Cell A1 shows duplicates also | ||||
10 | F | ie A is showing for the times it is in the col A | ||||
11 | R | I want that the list should show only | ||||
12 | T | unique items ie all the items in the list once. | ||||
13 | S | |||||
Sheet1 |