"BER" wrote:
I have a huge spreadsheet where my secretary entries patient names and other
important data I am wondering if she inputs a patient name on excel
spreadsheet twice is there any way the system could notify me/her of this?

One way is via Data Validation ..

Assuming name inputs are going down col A ..

Select col A
Click Data Validation
Allow: Custom
Formula: =COUNTIF(A:A,A1)<2
Click OK

Test it out ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---