Finding Duplicates.

[Jdillon606]

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 · Accepted solution]

@Jdillon606 

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?

[#3]

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