Forum Discussion
Solved
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 cell. Not the position the duplicate is found. Any help is appreciated
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?
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.
