Thread: What function will take the average of text data?
View Single Post
  #4   Report Post  
JE McGimpsey
 
Posts: n/a
Default
In article .com,
"Harlan Grove" wrote:

Somewhat shorter and more efficient is Leo Heuser's approach,

=INDEX(rng,MODE(MATCH(rng,rng,0)))

Thanks, Harlan!
Reply With QuoteReply With Quote