finding duplicate numbers

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

I have a list of zip codes (thousands of them) in a
column, is there a command that will find duplicate
numbers and turn them red?

thanks
 
This gives me info on finding duplicate number when there
are two columns, comparing one column against the other.

The data I have is all in one column. How can I find
duplicated in the same column and mark them red.

for example

60631
60632
60634
60631

the "60631" should be marked red.

thanks!!
 
Go back to the link John gave you and *READ* the item labelled:
"Highlighting Duplicate Entries", which addresses your request *exactly*.

It's right near the top of the page!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

See

http://cpearson.com/excel/duplicat.htm
 
Thanks! I saw that and after it didn't work for me I
made the mistake of thinking this was for a 2 column
worksheet.

Perhaps there is another issue with the way my cells are
formatted. I followed the listed formula exactly and
nothing happened.
 
<<"I followed the listed formula exactly and nothing happened">>

You mean you named your range "Range1" also?
What cells did you assign to your range?
Did you also start in A5?
How did you assign them?

Excuse this question, but I once had a poster apply the formula to an
adjoining column, and expected it to work.
You didn't do anything similar to that, did you?
--


Regards,

RD
--------------------------------------------------------------------
Please keep all correspondence within the Group, so all may benefit!
-------------------------------------------------------------------

Thanks! I saw that and after it didn't work for me I
made the mistake of thinking this was for a 2 column
worksheet.

Perhaps there is another issue with the way my cells are
formatted. I followed the listed formula exactly and
nothing happened.
 
Frank

I copied the formula off the web and pasted it into the
conditional formatting box. I'm using Excel 2000,
English as far as I know. I went into "about excel" and
it does state that the spell check and dictionary are
french.

thanks
Jack
 
Very logical question.
Yes I made my data start on cell A5 (as per the formula)

I thought by highlighting my selection, that was my
Range. But based on your question below I think I'm
wrong. I need to go and figure out how to select/name my
range and then I think this will work.

Thanks for all your help, I understand it's been
frustrating. ;-)
 
Select your cells.
While they're *still* selected, click in the name box (left of the formula
bar), and type in the name "Range1" (no quotes), and hit <Enter>.

You've now named your range!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Very logical question.
Yes I made my data start on cell A5 (as per the formula)

I thought by highlighting my selection, that was my
Range. But based on your question below I think I'm
wrong. I need to go and figure out how to select/name my
range and then I think this will work.

Thanks for all your help, I understand it's been
frustrating. ;-)
 
Hi
what does the following formula return if entered in your spreadhsheet:
=IF(A1=A1,"X","")

Does it return a #NAME error?
If yes you have to use the french function names
 
PERFECT! Thank you very much for your help. It worked!!

You've saved me hours of work.
-----Original Message-----
Select your cells.
While they're *still* selected, click in the name box (left of the formula
bar), and type in the name "Range1" (no quotes), and hit
Click to expand...
You've now named your range!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Very logical question.
Yes I made my data start on cell A5 (as per the formula)

I thought by highlighting my selection, that was my
Range. But based on your question below I think I'm
wrong. I need to go and figure out how to select/name my
range and then I think this will work.

Thanks for all your help, I understand it's been
frustrating. ;-)

-----Original Message-----
<<"I followed the listed formula exactly and nothing happened">>

You mean you named your range "Range1" also?
What cells did you assign to your range?
Did you also start in A5?
How did you assign them?

Excuse this question, but I once had a poster apply the formula to an
adjoining column, and expected it to work.
You didn't do anything similar to that, did you?
--


Regards,

RD
--------------------------------------------------------
Click to expand...
- -
----------

Thanks! I saw that and after it didn't work for me I
made the mistake of thinking this was for a 2 column
worksheet.

Perhaps there is another issue with the way my cells are
formatted. I followed the listed formula exactly and
nothing happened.


.
Click to expand...

.
Click to expand...
 
Frank

It returned an "X". But I figured out my problem.
Thanks for trying to help me it, I appreciate it.

Jack
-----Original Message-----
Hi
what does the following formula return if entered in your spreadhsheet:
=IF(A1=A1,"X","")

Does it return a #NAME error?
If yes you have to use the french function names

--
Regards
Frank Kabel
Frankfurt, Germany

Frank

I copied the formula off the web and pasted it into the
conditional formatting box. I'm using Excel 2000,
English as far as I know. I went into "about excel" and
it does state that the spell check and dictionary are
french.

thanks
Jack
-----Original Message-----
Hi
how did you enter your formulas (in the conditional format dialog).
also what excel version are you using (non-English?)

--
Regards
Frank Kabel
Frankfurt, Germany

Thanks! I saw that and after it didn't work for me I
made the mistake of thinking this was for a 2 column
worksheet.

Perhaps there is another issue with the way my cells are
formatted. I followed the listed formula exactly and
nothing happened.

-----Original Message-----
Go back to the link John gave you and *READ* the item
labelled:
"Highlighting Duplicate Entries", which addresses your
request *exactly*.

It's right near the top of the page!
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================

(e-mail address removed)...
See

http://cpearson.com/excel/duplicat.htm
Click to expand...
Click to expand...
Click to expand...
 
Back
Top