| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Value that exists more than all other values
Good Afternoon,
I'm having trouble trying to write a function that returns the value in a given row that exists more than all other values in that same range. Please see the below example. A1 = Apple B1 = Banana C1 = Orange D1 = Apple E1 (Formula) = This cell should return Apple because Apple is listed in more cells than all other fruits. Thank you, Adam |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check if text exists within a cell range and return logical vaule - possible? | Excel Discussion (Misc queries) | |||
| Return adjacent cell if conditional formatting exists. | Excel Worksheet Functions | |||
| Match return #NA ...though item exists! | Excel Discussion (Misc queries) | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
| check if reference exists, then return its value or return 0 | Excel Worksheet Functions | |||
Threaded Mode
