PDA

View Full Version : Finding duplicate records



13-04-1999, 07:42 PM
I write hundreds of invoices a week in nzho 4. Sometimes I double invoice the customer and need a way to find duplicate invoices.
At the moment I export the invoices to Access and run a query to find duplicates in a field.
I would much rather use Excel, as they end up there anyway for another process.
Is there any way I can check a column in Excel for duplicate cells?
Of course it would be even easier to set a no duplicate field in NZHO 4, but I hav'nt been able to do that yet.