double numbers

[thijs]

Is there any way to see all the double numbers (not unique) in a colum (18000 rows)?

 

[Aladin Akyurek]

On 2002-05-11 14:15, thijs wrote:
Is there any way to see all the double numbers (not unique) in a colum (18000 rows)?

You could Cond Format the range using the formula as in

=COUNTIF($A$1:$A$18000,A1)>1

and choosing a background color.
This message was edited by Aladin Akyurek on 2002-05-11 14:19

 

[sen_edp]

hello

You can use conditional formatting.
in the formula is put the following
=if(countif($a$1:$a$18000,a1)>1,true,false)

and all the double cells will be formatted as you wish

Hope that helps



_________________
Best Regards,<font color="blue"><font size=+1><font color="red"> Andreas
This message was edited by sen_edp on 2002-05-11 16:42

 

[thijs]

Please tell me more, because as newbie i still don't know how to do this.

Thijs

On 2002-05-11 14:25, sen_edp wrote:
hello

You can use conditional formatting.
in the formula is put the following
=if(countif($a$1:$a$18000,a1)>1,true,false)

and all the double cells will be formatted as you wish

Hope that helps



_________________
Best Regards,<font color="blue"><font size=+1><font color="red"> Andreas
This message was edited by sen_edp on 2002-05-11 16:42

 

[Aladin Akyurek]

Thijs,

Zo moeilijk is het ook weer niet.

Lets say that you want to hilite non-unique itemms in A1:A100.

Select A1:A100.
Activate the option Format|Conditional Formatting.
Select Formula is for Condition 1.
Enter as formula in the empty box:

=COUNTIF($A$1:$A$100,A1)>1

Activate the Format button.
Activate Patterns tab.
Select color red.
Activate OK, OK.

You're done.

 

[thijs]

Aladin,

Where can I find in the dutch version of Excel:

Format|Conditional Formatting.

(really a newbie, or a dummy who needs help???)

Thanks

On 2002-05-12 05:29, Aladin Akyurek wrote:
Thijs,

Zo moeilijk is het ook weer niet.

Lets say that you want to hilite non-unique itemms in A1:A100.

Select A1:A100.
Activate the option Format|Conditional Formatting.
Select Formula is for Condition 1.
Enter as formula in the empty box:

=COUNTIF($A$1:$A$100,A1)>1

Activate the Format button.
Activate Patterns tab.
Select color red.
Activate OK, OK.

You're done.

 

[Aladin Akyurek]

Where can I find in the dutch version of Excel:

Format|Conditional Formatting.

Opmaak|Voorwaardelijk..

Download

HelpIDs.exe (associated with Ron de Bruin)

at

http://www.j-walk.com/ss/excel/tips/tip89.htm

 

[thijs]

And.......YES there is still hope for dummy's.
It works perfect.
Thanks a lot. You where very helpfull.

Thijs