I have searched the forums and found some discussion on this topic. Unfortunately I haven't found an answer that has worked yet.
I am trying to write a formula that would return the most common text value. Named range is ServiceLevel - formula is below
=INDEX(Servicelevel,MAX(MATCH(Servicelevel,Servicelevel,0)))
The value returned is actually the 2nd most common value in the range. I received this same incorrect using an array formula and without the named range.
Any help would be appreciated. Thanks!
Bookmarks