Condition that meets one condition

[pto160]

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,

[

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

 

[arthurbr]

Wouldn't this have counted already in post 4?

You're completely right. My bad. Apologies to the OP