Conditional Formating Problam and question?
 

I have a couple thousand names in Column A going down. After i put in a
formula that i found on another site.. It highlighted some duplicates, but
not all...I tried re-sorting the whole column, it highlighted a few more
names but still not all duplicates. (if possible i could do it without having
to sort,,because it take forever to sort thousands of names.)

I dont remember what formula it was, but i have a feeling the cell range
wasnt correct...
Can you please give me a formula that will highlight all(not just some)
duplicates in the full column A all the way down assuming "A60,000"

Conditional Formating Problam and question?
 

Try:

Highlight column A :

CF

FormulaIs: =COUNTIF(A:A,A1)1

Select colour

OK

"Jman" wrote:

I have a couple thousand names in Column A going down. After i put in a
formula that i found on another site.. It highlighted some duplicates, but
not all...I tried re-sorting the whole column, it highlighted a few more
names but still not all duplicates. (if possible i could do it without having
to sort,,because it take forever to sort thousands of names.)

I dont remember what formula it was, but i have a feeling the cell range
wasnt correct...
Can you please give me a formula that will highlight all(not just some)
duplicates in the full column A all the way down assuming "A60,000"

Conditional Formating Problam and question?
 

That's it.. it worked.....You guys are awesome... Best service i've seen on
line.
Thanks for the quick response.
Julian

"Toppers" wrote:

Try:

Highlight column A :

CF

FormulaIs: =COUNTIF(A:A,A1)1

Select colour

OK

"Jman" wrote:

I have a couple thousand names in Column A going down. After i put in a
formula that i found on another site.. It highlighted some duplicates, but
not all...I tried re-sorting the whole column, it highlighted a few more
names but still not all duplicates. (if possible i could do it without having
to sort,,because it take forever to sort thousands of names.)

I dont remember what formula it was, but i have a feeling the cell range
wasnt correct...
Can you please give me a formula that will highlight all(not just some)
duplicates in the full column A all the way down assuming "A60,000"

Conditional Formating Problam and question?
 

Thanks for the feedback.

"Jman" wrote:

That's it.. it worked.....You guys are awesome... Best service i've seen on
line.
Thanks for the quick response.
Julian

"Toppers" wrote:

Try:

Highlight column A :

CF

FormulaIs: =COUNTIF(A:A,A1)1

Select colour

OK

"Jman" wrote:

I have a couple thousand names in Column A going down. After i put in a
formula that i found on another site.. It highlighted some duplicates, but
not all...I tried re-sorting the whole column, it highlighted a few more
names but still not all duplicates. (if possible i could do it without having
to sort,,because it take forever to sort thousands of names.)

I dont remember what formula it was, but i have a feeling the cell range
wasnt correct...
Can you please give me a formula that will highlight all(not just some)
duplicates in the full column A all the way down assuming "A60,000"