| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Too many nested "IF"'s: a work around needed for this example...
Biff wrote:
Hi! Enter this in I2: =INDEX($B$1:$H$1,MATCH(SMALL($B2:$H2,COUNTIF($B2:$ H2,0)+COLUMNS($A:A)),$B2:$H2,0)) Copy across to J2. Then select both I2 and J2 and copy down to row 10. Biff This seems to do the trick!! Nice work around. Thank you Biff. All the other suggestions also worked as well. Thanks all. Bullman |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested subtotals don't work properly after applying recommendation | Excel Worksheet Functions | |||
| Nested IF - Work Around for 7 nest Max | Excel Worksheet Functions | |||
| Sumproduct help needed! | Excel Worksheet Functions | |||
| Nested if, sum & vlookup Function | Excel Worksheet Functions | |||
| Nested If/Then Math Expert Needed | Excel Worksheet Functions | |||
Hybrid Mode
