Highlighting duplicate data entry

A

Alan Flint

Can someone help me please ?

I am manipulating a large spreadsheet where I have to
enter invoice numbers. I often enter invoice numbers that
already exist further up the spreadsheet. Is there any way
of identifying if the data I am entering already exists ?

Thanks
Alan
 
Top