Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CHANGE A FORMULA
Hello,
How could I modify the formula below to only include results that have "FEMALE" in column 'R'? This formula pulls and displays the name in column 'L' if all criteria are met, but I only want the name displayed if column 'R' is "FEMALE". I want to add that criteria. Does that make sense? =IF(ROWS($1:2)COUNT(OFFSET($R:$R,,MATCH($A$1,$S$1 :$T$1,0))),"",INDEX(L:L,SMALL(OFFSET($R:$R,,MATCH( $A$1,$S$1:$T$1,0)),ROWS($1:2)))) Thanks in advance for any help. I really appreciate it. tgcali |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
change color of all cells with formula or are part of a formula | Excel Discussion (Misc queries) | |||
copy formula down a column and have cell references change within formula | New Users to Excel | |||
How does Data Validation change with a formula change? | Excel Worksheet Functions |