Forum Discussion
How to get a result of column values that have not a unique value in another column
Please help I want to check if column Facility has unique values in column Sector In the below case I would like to see the result : Facility 1 and 2 Facility Sector 1 A 2 A 3...
can you provide the same result with unique and filter? (Office365 or 2021)
With 2021/365. Probably what OliverScheurich had in mind:
in D2:
=LET(
Facility, A2:A8,
uFacility, UNIQUE(Facility),
FILTER(uFacility, COUNTIF(Facility,uFacility) > 1)
)
- is it possible that you upload the excel sheet? i have office 365 but it does not seem to work
Sample attached...