Forum Discussion
Solved
Generate Unique List from Duplicate Values and Date Constraints
I have a set of non-unique values for suppliers with corresponding activity dates. The desired outcome is to create a unique set of suppliers with the following activity date constraints: 1. Last_Ac...
=UNIQUE(FILTER(A2:A21,(COUNTIFS($A$2:$A$21,$A$2:$A$21,$C$2:$C$21,$D$4)=0)*(COUNTIFS($A$2:$A$21,$A$2:$A$21,$C$2:$C$21,">"&$D$6)>0)))This formula returns the result in my sheet.
That is why it is not in the outcome. You are probably mistaken ABC with AC 🙂