| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count and lookup
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
count and lookup
That is just
=MODE(A2:A20) -- HTH RP (remove nothere from the email address if mailing direct) "eoht" wrote in message ... 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Lookup | Excel Discussion (Misc queries) | |||
| Formula to lookup Multiple Column Text and then Count Result | Excel Worksheet Functions | |||
| count in a lookup ? | Excel Discussion (Misc queries) | |||
| lookup, count | Excel Worksheet Functions | |||
| Count and Lookup | Excel Worksheet Functions | |||
Linear Mode
