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)
=IF(COUNTA(UNIQUE(FILTER($B$2:$B$8,$A$2:$A$8=E2)))>1,"not unique","unique")This would return the same result as already shown with Excel 2013.
However Lorenzo solution seems to be exactly what you are looking for.
How many rows are in your dataset? I've tried the other formula for 20000 rows and it didn't return an error.