View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AdamE AdamE is offline
external usenet poster
 
Posts: 3
Default 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