Finding Duplicates.

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 cel...

excel

Formulas and Functions

training

dscheikey
Sep 26, 2022
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?

dscheikey

Bronze Contributor

Sep 26, 2022

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?

Jdillon606
Copper Contributor
Sep 26, 2022
That’s fantastic. I knew it was simple. Thanks sooo much.

Forum Discussion

Finding Duplicates.

Resources