The company I work for uses Excel for their billing and invoices.... We have run into a snag with one of our customers.
They give use unique billing numbers for each job we do for them and pay according to those numbers. If there is a duplicate on the invoice, then the first is paid and the second is knocked out of the system and not paid.
Is there anyway in Excel to set a column to only accept unique entries and output and error if a duplicate is entered?
Topic Locked
Posted - 09 February 2004 : 17:00:53
