Evaluating a range based on condition of other columns

[goku239]

Greetings,

Is there a formula for the accept/reject column where it evaluates to see if the Dollars column have the same values based on the grouping of Name and age?

For example below, 20 yr old Mike has two entries and the Dollars are the same value for both, so I would accept.

10yr old Mike has 3 entries, but they are not all the same in the Dollars, so I would reject.

Any help would be greatly appreciated

Thank you

Name	Age	Dollars	accept/reject
Mike	20​	100​	accept
Mike	20​	100​	accept
Mike	10​	200​	reject
Mike	10​	201​	reject
Mike	10​	200​	reject

 

[Eric W]

Welcome to the MrExcel board!

Try:

Book1
	A	B	C	D
1	Name	Age	Dollars	accept/reject
2	Mike	20	100	Accept
3	Mike	20	100	Accept
4	Mike	10	200	Reject
5	Mike	10	201	Reject
6	Mike	10	200	Reject
Sheet11

Cell Formulas
Range	Formula
D2:D6	D2	=IF(COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2,$C$2:$C$10,C2)=COUNTIFS($A$2:$A$10,A2,$B$2:$B$10,B2),"Accept","Reject")

 

[goku239]

That worked wonders! Thank you so much!

 

[Eric W]

Happy to help! Thanks for the feedback.