Thread
:
What function will take the average of text data?
View Single Post
#
3
Harlan Grove
Posts: n/a
JE McGimpsey wrote...
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):
=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rn g,rng),0))
....
Somewhat shorter and more efficient is Leo Heuser's approach,
=INDEX(rng,MODE(MATCH(rng,rng,0)))
Reply With Quote