Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Discard Repeated Data?
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Discard Repeated Data?
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 "evoxfan" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Repeated Data? | Excel Discussion (Misc queries) | |||
How to find out repeated data | Excel Worksheet Functions | |||
delete repeated data in excel | Excel Discussion (Misc queries) | |||
check for repeated data | Excel Discussion (Misc queries) | |||
Printing text in a repeated cell/row that is longer than repeated | Excel Discussion (Misc queries) |