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"

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"

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"

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"