MS Excel – Indication of duplicate values

An hour ago I had to look for duplicate values in a spreadsheet. I looked for a minute in google and found plenty of solutions, as you can imagine. One of the best was described here, but it is quite useless, as far as you have to indicate how many times the values are duplicate and it is quite unuseful. So, I have edited the formula a little and here is the new one:


And if you want to make it useful, you can put the formula in a conditional statement, and answer with “duplicate” in stead of “true” and nothing in stead of “false”. This is how it looks like:


It is useful and it works always! Use it for free 🙂

Tagged with: ,