Forum Discussion
Kenneth Green
Mar 22, 2024Copper Contributor
Formula look at range of cells in colum, find duplicates & return the the dup that appears the most.
Windows 10 Excell 2029 I need a formula that looks at cells in a range, finds any duplicate and returns the duplicate that appears the most. An example would be Column A Butter Milk Butter ...
- Mar 22, 2024
Use MODE.SNGL or MODE.MULT.
Kenneth Green
Mar 22, 2024Copper Contributor
Hi Detlef
Is that available in Excel 2019?
Is that available in Excel 2019?
Kenneth Green
Mar 22, 2024Copper Contributor
Opps do not worry it is.
Thank you for your suggestion and I will go and try it out
Thank you for your suggestion and I will go and try it out