Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Filter based on condition

OCM

OCM

MIS
Joined
Sep 12, 2002
Messages
233
Location
US
Hi,
I have a large dataset where I need to filter out only occurrences of A0020 codes with the following three codes within a week time.
B0480
C0481
D0550
In other words, the above three codes should not be occur with A0020. Attached is the sample file with the expected result on the second tab..

TIA

Regards,
 

Attachments

You must log in or register to reply here.

Similar threads

OCM
  • Solved
Apply Filter
Replies
6
Views
752
OCM
OCM
Kennelbloke
  • Locked
  • Solved
Excel Unique-Filter issue
Replies
3
Views
792
SkipVought
S
GPnew
  • Locked
  • Question Question
Power Pivot Filter out Rows where data is not in all columns
Replies
14
Views
2K
combo
combo
bkoopers
  • Locked
  • Question Question
Problem with Excel pasting into filtered cells
Replies
1
Views
706
combo
combo
pendle666
  • Locked
  • Question Question
Change colour of cells based on dropdown list value in another - Excel professional plus 2016
Replies
5
Views
635
pendle666
pendle666

Part and Inventory Search

Sponsor

Back
Top