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.
In case of Jul-22 you have 5 unique supplier (ABC Tekstil, AC Tekstil, Meyer, Swinger, Viskos Teks). How your output is only 3?
There is a condition that they should not have any activities in August, thus AC Tekstil and Swinger are out, leaving me with three.