I would use conditional formatting. I have created an example and uploaded
it to http://cjoint.com/?bAkX4b3i5Q for you to check-out.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"wycherley" wrote
in message ...

Hello

Can someone tell me the best way to set up a spread sheet. that will
log peoples names and an activity that they have chosen for an after
school club. But i need there to be a coloum that automaticaly brings
up names that apear more than once.

Thankyou


--
wycherley
------------------------------------------------------------------------
wycherley's Profile:
http://www.excelforum.com/member.php...o&userid=30857
View this thread: http://www.excelforum.com/showthread...hreadid=505249