| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select only Text duplication
Thank you very much OssiMac. It works perfectly.
"OssieMac" wrote: =AND(COUNTIF($A:$A,A1)1,NOT(ISNUMBER(A1))) -- Regards, OssieMac "BEE" wrote: Hello Everyone, I am using Conditional Formatting "=COUNTIF($A:$A,A1)1" to check duplication in one column. I have texts and also numbers in the same column. How can I make the Conditional Formatting to only check for Text duplication and not numbers. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Duplication | Excel Discussion (Misc queries) | |||
| select text in cell based on text from another cell, paste the text at the begining of a thrid cell, etc... | Excel Programming | |||
| Text desappears when I select wrap text | Excel Discussion (Misc queries) | |||
| no duplication please | Excel Programming | |||
| Duplication | Excel Programming | |||
Hybrid Mode
