LinkBack URL
About LinkBacks
Hi Folks
Where Cols B and C have rows grouped with the same value and Col X has a value >=3 then Col P is to return Y or N
Sample Workbook with expected outcome attached.
Cheers
hammer
Hi Folks
Where Cols B and C have rows grouped with the same value and Col X has a value >=3 then Col P is to return Y or N
Sample Workbook with expected outcome attached.
Cheers
hammer
If you have found solving my problem/s to be an interesting and educational exercise then how about Repping me up?
No idea why I need Rep, other than feeling left out....
try this formula in cell P2 & drag down:
Formula:
Please Login or Register to view this content.
Hi jewelsharma
Thanks for the reply but I need the Groups to return either Y or N only.
So if just one of the values is less than 3 then the entire Group must return N
Cheers
maybe this...
P2: =IF(MIN(IF((B$2:B$20=B2)*(C$2:C$20=C2),X$2:X$20))<3,"N","Y")
Array formula: Press Ctrl+Shift+Enter, not just Enter
Copy down
Just Enter ...
=IF(AGGREGATE(15,6,X$2:X$20/(B$2:B$20=B2)/(C$2:C$20=C2),1)<3,"N","Y")
No luck with either of the last two posts either folks.
Hi hammer,
Teethless mama's does that. I tested it. I see no reason why Phuocam's won't do that, either.So if just one of the values is less than 3 then the entire Group must return N
Can you post something that will show why those aren't doing what you want?
Dave
hammer2,
I've tried both formulas, and they both return the desired result. (see attached)
What results are you getting?
Please review and also consider to "Add Reputation" to both Teethless Mama and Phuocam for their brilliant formulas.
The formulas would not work for subsequent groups in the actual Workbook.
The problem with both was the $ lock in the second part of (B$2:B$20)
After removing that '$' both formulas worked fine(I do get some things worked out all by myself)
Thanks to all for the solutions and input.
Good to hear it.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks