ExcelBanter - Select only Text duplication

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Select only Text duplication (https://www.excelbanter.com/excel-programming/420589-select-only-text-duplication.html)

Bee

Select only Text duplication

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.

OssieMac

Select only Text duplication

=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.

Bee

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.

All times are GMT +1. The time now is 10:55 PM.