Duplicate Filter with more conditions

Hi ,

I want to add another condition for duplicate selection. How to add Column 2 to the duplicate flter condition.

1. Select row for a Product with earliest date but if Column 2 is “No” then select that without any consideration .

So for Product 2 -4th row is selected as it has earliest date in product 2 but for Product 1 first row needs to be selected as Column = NO

How can i add Column 2 in duplicate Filter condition.

| Column 1  | Column 2 | Column 3  | Column 4 |
| Product 1 | No       | 5/10/2025 |          |
| Product 1 | Yes      | 2/10/2025 |          |
| Product 1 | Yes      | 3/10/2025 |          |
| Product 2 | Yes      | 1/10/2025 |          |
| Product 2 | Yes      | 2/10/2025 |          |
| Product 2 | Yes      | 3/10/2025 |          |

Thanks,