alderman
New member
- Joined
- Jan 23, 2014
- Messages
- 19
- Reaction score
- 0
- Points
- 0
What I am looking for is a method to check from a long list if from the same Number set, if the Category D has greater days than any other higher category (A, B, C). I have been tinkering with an if(Countifs()) equation, but I cannnot get it to work.
So in the data set below I would like a fourth column that would say Yes/No. In the first dat set below it would be a Yes result as there is a D with more Days than a B.
In the next data set the result would be "no" as there are no D's
In this next data set the answer would be no, as the D has less days than the C's.
Any suggestions?
So in the data set below I would like a fourth column that would say Yes/No. In the first dat set below it would be a Yes result as there is a D with more Days than a B.
Number | Cat | Days |
CS140012 | B | 1562.51 |
CS140012 | B | 471.96 |
CS140012 | C | 1695.88 |
CS140012 | D | 557.14 |
CS140012 | D | 517.41 |
CS140012 | D | 237.61 |
CS140012 | E | 0.00 |
CS140012 | E | 0.00 |
In the next data set the result would be "no" as there are no D's
Num | Cat | Days |
CD140014 | B | 3450.00 |
CD140014 | B | 2315.71 |
CD140014 | B | 1434.57 |
CD140014 | B | 1376.97 |
CD140014 | B | 1140.36 |
CD140014 | C | 8070.00 |
CD140014 | C | 4594.23 |
CD140014 | C | 210.44 |
CD140014 | E | 0.00 |
CD140014 | F | 0.00 |
In this next data set the answer would be no, as the D has less days than the C's.
Num | Cat | Days |
CD140015 | C | 870.00 |
CD140015 | C | 319.60 |
CD140015 | D | 318.40 |
CD140015 | E | 0.00 |
CD140015 | E | 0.00 |
Any suggestions?