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...
=IF(SUM(N(IF($A$2:$A$8=D3,MATCH(IF($A$2:$A$8=D3,$B$2:$B$8),IF($A$2:$A$8=D3,$B$2:$B$8),0)=ROW($1:$7))))>1,"not unique value","unique value")You can try this formula which seems to work in my sheet. Enter the formula with ctrl+shift+enter if you don't work with Office365 or 2021.
If you work with Office365 or 2021 you can apply functions such as UNIQUE and FILTER functions which should simplify the task considerably.
When doing these checks on a large dataset excel responds:
excel ran out of resources while attempting to calculate. as a result the formulas cannot be revaluated.
excel ran out of resources while attempting to calculate. as a result the formulas cannot be revaluated.