| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight Duplicate Values in a Range
Also, when I try to modify your formula to cover the desired range of
A1:T93 so that it looks like: =if(countif(A$1:T$93,A1)2 and click OK, I get a message telling me there's an error in the formula, and I can't figure out how to resolve it. Even if I use your formula verbatim just to test column A instead of the entire range, I still get an error message. So I must be interpreting something wrong in what you are trying to tell me. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Identifying duplicate values in a range | Excel Discussion (Misc queries) | |||
| Duplicate values in range of fields | Excel Discussion (Misc queries) | |||
| How to Highlight Two Rows With Two Columns of Duplicate Values | Excel Worksheet Functions | |||
| how do i prevent duplicate values in a range of validated cells? | Excel Discussion (Misc queries) | |||
| is there a formula that remove duplicate values from a range | Excel Worksheet Functions | |||
Hybrid Mode
