simple sheet ?

[Keith]

Hi

Would it be possible to have a Simple Spread Sheet that would recognise the
input of the SAME number if it were entered three times and then highlight
that number in a different place and the number could be anything between 1
and 2000

 

[ianripping]

You could have a helper column in b.

if all the numebrs are in col a.

have an equation in b1:-

=countif(a:a=a1)

and in c1

if(b1=>3,("This number has appeared three times "&b1),"")

copy this formula down.

this the kinda thing ure after

 

[Dave Hawley]

Hi Keith

I would say Condidional Formatting could suit your needs. See
"Highlighting Duplicates" on this page;
http://www.ozgrid.com/Excel/Formulas.htm

** Posted via: http://www.ozgrid.com
Excel Templates, Training, Add-ins & Business Software Galore!
Free Excel Forum http://www.ozgrid.com/forum ***

 

[Keith]

Thanks for the reply
i just get an error wityh that one cheers ne way

 

[Keith]

Thanks for your re[ply