Forum Discussion
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 ...
Use MODE.SNGL or MODE.MULT.
Use MODE.SNGL or MODE.MULT.
Hi Detlef
Is that available in Excel 2019?
Is that available in Excel 2019?
- Opps do not worry it is.
Thank you for your suggestion and I will go and try it out
