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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Delete all data after a symbol in a field 0
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Duplicate entry in a column/row 14
Formating bolded text exclusively. 0
How do I auto highlight a cell with the same data as another cell 11
Linking data in MS Word into Excel 5
Combobox filtering 2

Top