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)?
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
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.