Invoice Number duplicate Check
 

I have a spreadsheet with a bunch of invoices. Is there a way for me to
check to see if any duplicates exist as i type in the cell. example would be
cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter
and a messge comes up saying invoice number exists.

Invoice Number duplicate Check
 

See:

http://cpearson.com/excel/NoDupEntry.aspx

In article ,
JOSEPH WEBER wrote:

I have a spreadsheet with a bunch of invoices. Is there a way for me to
check to see if any duplicates exist as i type in the cell. example would be
cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter
and a messge comes up saying invoice number exists.

Invoice Number duplicate Check
 

http://www.contextures.com/xlcondfor...html#DupColumn
http://v.mcomet.com/detail/3348431/

HTH,
Ryan--

--
RyGuy


"JE McGimpsey" wrote:

See:

http://cpearson.com/excel/NoDupEntry.aspx

In article ,
JOSEPH WEBER wrote:

I have a spreadsheet with a bunch of invoices. Is there a way for me to
check to see if any duplicates exist as i type in the cell. example would be
cell a2 has invoice number 12345, then i type in cell a3 12345 and hit enter
and a messge comes up saying invoice number exists.