Hi,

Am Fri, 23 Nov 2012 08:32:16 -0800 (PST) schrieb naga rajan:

A1=6 B1=5 C1=6 D1=4 E1=6.

In F1 I should print "3" since 6 is repeated 3 times.

try in F1:
=COUNTIF(A1:E1,MODE(A1:E1))


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2