Discard Repeated Data?

E

evoxfan

I receive a weekly report such as:

PO # Vendor Cost Code Amount Currency Xchng USD
99-100-PO-001 DONALD D44250 50,000.00 YTL 1.66 $30,089.69
99-100-PO-002 DAFFY D26300 10,000.00 EUR 0.98 $10,218.50
99-100-PO-003 MICKEY D42070 35,000.00 USD 1 $35,000.00

This report has all P/O's, old and new. There could also be over a thousand
P/O's. I am interested in only the new P/O's that I have not received on any
the previous week's report.

What is the best way to filter or delete previous P/O's and view only new
P/O's?
Pivot table, filter, formulas, or macros?

Thanks for any suggestions.
 
B

Bernie Deitrick

Use a column of formulas like

=ISERROR(MATCH(A2,OldPOSheet1!A:A,False))

the sort based on that column, and only keep the rows where the formula
returns TRUE.

HTH,
Bernie
MS Excel MVP
 
Top