I have Excel 365. I am trying to see if it is possible to extract data where the order number only has REVERSAL as type and not any other types.
Is there a way to exclude other types without specifying each one and only include REVERSAL? If an order for example had REVERSED and ACTIVE then that would be excluded. Here is the example.
The results are 200 and 500 as they only have REVERSAL,
[
Is there a way to exclude other types without specifying each one and only include REVERSAL? If an order for example had REVERSED and ACTIVE then that would be excluded. Here is the example.
The results are 200 and 500 as they only have REVERSAL,
[
Book1 | ||||
---|---|---|---|---|
A | B | |||
1 | Order | Type | ||
2 | 100 | REVERSAL | ||
3 | 100 | Active | ||
4 | 200 | REVERSAL | ||
5 | 300 | REVERSAL | ||
6 | 300 | Active | ||
7 | 300 | Posted | ||
8 | 500 | REVERSAL | ||
9 | ||||
10 | The result I would like | |||
11 | 200 | REVERSAL | ||
12 | 500 | REVERSAL | ||
Sheet1 |