Using Array Formulas in Excel - Examples: Find if a list has duplicate items | Chandoo.org - Learn M

@Denise, as Robert pointed, I have been using European version of excel which uses ; to seperate formula arguments instead of comma. So when I copy pasted the formula from my test workbook, I forgot to change the semicolon back to comma. I have corrected

chandoo.org