View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Munchkin 76 Munchkin 76 is offline
external usenet poster
 
Posts: 1
Default Microsoft Excel Formula Help

I need a formula that will do this:

Lets just say there are five values

FALSE
Team A
Team B
Team C
Team D

Here are the value properties

False - nothing
Team A - higher than false but lower than B C or D
Team B - higher than false and A but lower than C or D
Team C - higher than false, A or B but lower than D
Team D - higher than all other teams

Other formulas have created a list that could contain one of these 5 values
or a multiple of them and it needs to return a value based on below:

If it contains false plus team a, then it returns team a
If it contains false plus team a and team b, then it returns team b
If it contains false plus team b and team c, then it returns team c
If it contains false plus team c and team d, then it returns team d
if it contains false plus team a and team b and team c and team d, it
returns team d

How do you do that?