Get rid of no matching rows|Power Query|Excel Forum|My Online Training Hub

Hi Guys,

i have table like here:

Name|Color|Age

and NamedRange in workbook like here:

InputToTake = 3

The composite Key here is Name&Color.

What i want to do is get rid of 2nd row with Dog and Green.
Why? Because Name&Color is the same and only differ with Age field. For Dog it is 2 and for Monkey is 3.So i want to keep row with Age= 3 because InputToTake = 3

So i bouilt query where result is :

Name|Color|Age|InputToTake

 So i want to get rid of Dog because:

1. Age is different than Input to Take
2. The row is duplicated because of keys: Name and Color, only Age is different which i have to check.

How can i do this?

In attachment please find workbook with example.

Please help,
Jacek