count and lookup

E

eoht

I have a list of customers IDs and want to lookup the top customer from that
list.

For example in column B:

Customer ID
122
432
444
122
987
432
122
987
122

I need a function that will be able to lookup and give me the customer ID
that shows up the most, in this example its Customer ID: 122. Thanks.
 
B

Bob Phillips

That is just

=MODE(A2:A20)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top