Mar 22 2024 06:22 AM - edited Mar 22 2024 06:23 AM
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
Butter
Bread
Banana
and the formula result would be Butter in Cell C2
I already have the code that looks at Column A and I have marked where the 2nd formula would be.
Either version of the formula is entered into C2 and looks at cell A2.
If A2 is NOT null then the formula that I am looking for would run
and return the result in C2
A1 Format
'=IF(A2="","","Code Goes Here")
R1C1 Format
Range("C2").Select
ActiveCell.FormulaR1C1 = "=IF(RC[-2]="""","""",""Code Goes Here"")"
Thank you in advance
Mar 22 2024 06:51 AM
SolutionUse MODE.SNGL or MODE.MULT.
Mar 22 2024 08:42 AM
Mar 22 2024 08:49 AM
Mar 23 2024 04:44 AM
Mar 22 2024 06:51 AM
SolutionUse MODE.SNGL or MODE.MULT.