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,
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,
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