Please help me for the formula:
Request. Code. Progress
5 Ww01 4
8 Ff02 9
4 Ww04 5
To show only the code if request is higher than progress.
Sample: ww01
Please help me for the formula:
Request. Code. Progress
5 Ww01 4
8 Ff02 9
4 Ww04 5
To show only the code if request is higher than progress.
Sample: ww01
Is "5 Ww01 4" in one cell, or in 3 separate cells?
Quang PT
I think that htey are in separate cells... This array formula will do what you need.
=IFERROR(INDEX(B:B,SMALL(IF($A$2:$A$7>$C$2:$C$7,ROW($C$2:$C$7)),ROWS($1:1))),"")
Array Formulae are a little different from ordinary formulas in that they MUST be confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around the outside of your formula. If you do not CTRL+SHIFT+ENTER you will (almost always) get an error message or an incorrect answer. Press F2 on that cell and try again.
Don't type the curly braces yourself - it won't work...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks