Thanks:  0
Likes:  0

# Thread: double numbers

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

2. 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 ]

3. 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 ]

4. 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 ]

5. 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.

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.

7. Where can I find in the dutch version of Excel:

Format|Conditional Formatting.

Opmaak|Voorwaardelijk..

HelpIDs.exe (associated with Ron de Bruin)

at

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

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

Thijs

## User Tag List

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•