Forum Home
Press F1
 
Thread ID: 1251 1999-04-13 07:42:00 Finding duplicate records Guest (0) Press F1
Post ID Timestamp Content User
1602 1999-04-13 07:42:00 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.
Guest (0)
1