| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Validation for a cell
Dear expert,
I want to set a cell (for example : A1) with validation so that the value in it will not appear twice in a row, say A1:M1. My formula is: =COUNTIF($A$1:$M$1,A1)<=1. The above formula is working but I want the same validation also working for Column A, say A1:A10. The PC blocks me and it states a cell cannot be set more than one validation. Can this be done? If yes, what the formula will be? Please advise. Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| List, Data Validation, unlocked cell, protected sheet..... | New Users to Excel | |||
| In Cell Validation List & Linked Cell VLOOKUP | Excel Discussion (Misc queries) | |||
| Data Validation does not work when selecting another cell. | Excel Discussion (Misc queries) | |||
| Data Validation / Cell Entry | Excel Discussion (Misc queries) | |||
| how to add two data validation lists to a single cell? | Excel Worksheet Functions | |||
Threaded Mode
