Hi Guys,
i have table like here:
Name|Color|Age
| Monkey | green | 3 |
| Dog | green | 2 |
| Cat | Black | 3 |
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
| Monkey | green | 3 | 3 |
| Dog | green | 2 | 3 |
| Cat | Black | 3 | 3 |
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
Built a parameter query where I made the Input to Take the filter value in the main query.
File is attached for your review.
Thank you
