Finding Duplicates.

New Contributor

Hello everyone,


I am working on a file for my job(inventory management). I need a formula that would find if a number duplicates in 5 cells and if so the number needs to be placed in then 6th cell. Not the position the duplicate is found. Any help is appreciated 

2 Replies
best response confirmed by Jdillon606 (New Contributor)


The function MODE.SNGL() shows you the number that occurs most frequently in a range. This would not search for duplicate entries in every case. Even if the number occurs 3, 4 or 5 times, you would get the corresponding number as a result. If there are no identical numbers, you will get an error (#N/A). If you have 2 pairs of numbers, you will get the lower number as the answer.

Can you solve your problem with this function?


That’s fantastic. I knew it was simple. Thanks sooo much.