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]

Perhaps

 =FILTER(A2:B8;(COUNTIF(A2:A8;A2:A8)=1)*(B2:B8="reversal"))

 

[Peter_SSs]

Is it possible to have data like this?
If so, should 200 be included in the results?
If it should, should it be included once or twice?

23 08 09.xlsm
	A	B
1	Order	Type
2	100	REVERSAL
3	100	Active
4	200	REVERSAL
5	200	REVERSAL
6	300	REVERSAL
7	300	ACTIVE
8	500	REVERSAL
Sample

 

[pto160]

Thank you arthurbr for your formula.

Hi, Peter_SSs. Yes, it is possible to have data like this. The 200 should be included in the results as it has REVERSAL and nothing else. It should be included once.

 

[Peter_SSs]

Yes, it is possible to have data like this. The 200 should be included in the results as it has REVERSAL and nothing else. It should be included once.

Thanks for the clarification. In that case, try this

pto160_1.xlsm
	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	600	REVERSAL
10	600	REVERSAL
11
12
13	200	REVERSAL
14	500	REVERSAL
15	600	REVERSAL
Sheet1

Cell Formulas
Range	Formula
A13:B15	A13	=UNIQUE(FILTER(A2:B10,COUNTIF(A2:A10,A2:A10)=COUNTIFS(A2:A10,A2:A10,B2:B10,"REVERSAL"),""))
Dynamic array formulas.

 

[pto160]

Absolutely fantastic. This works great. Thank you so much for your help. This will really help me at work.

 

[Peter_SSs]

You are welcome. Glad to help.

 

[arthurbr]

Would have appreciated an acknowledgment...

 

[pto160]

arthurbr, I apologize humbly. Thank you so much for your help. That was an oversight on my part. Your solution works great as well. I will definitely use it as well at work. I will be more conscious of this in the future.

 

[Peter_SSs]

Would have appreciated an acknowledgment...

Wouldn't this have counted already in post 4?

Thank you arthurbr for your formula.