Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
EDIT FORMULA BAR in excel 2003? why not? where is it? | Excel Worksheet Functions | |||
Excel instance used with "Export to Microsoft Excel" option in Internet Explorer | Excel Discussion (Misc queries) |