MrExcel Publishing
Your One Stop for Excel Tips & Solutions

preventing data duplication

Posted by Chris O'Baugh on July 24, 2001 7:17 PM

WE use Excell to track invoices at work. I've been looking for a way to have Excell somehow alert us to duplicate data entries.

Any suggestions??

Posted by Richard S on July 24, 2001 11:15 PM

There's probably a beter way, but I have a large spreasheet with G/L account numbers in it. To ensure i don't duplicate any, I have another column next to the G/L account number with the formula =COUNTIF(Range,A1), where A1 is the cell to the left, and Range is the named range for all the G/L numbers. If the result is more than 2, there is a duplication.

Posted by Aladin Akyurek on July 24, 2001 11:39 PM

For an alternatice, see: