Column Formula for summarizing data within a group based on values in 2 columnsHi everyone -
I am looking for a column formula that would return the desired column below. The sample data table has 3 rows per group just for this example. It is possible for each group to have a different number of rows of data.
Any help appreciated, thanks!
| Group | Time | Score | First Time Failed (Desired Column) |
| A | 1 | Pass | 7 |
| A | 3 | Pass | 7 |
| A | 7 | Fail | 7 |
| B | 1 | Pass | Pass |
| B | 2 | Pass | Pass |
| B | 6 | Pass | Pass |
| C | 1 | Pass | 3 |
| C | 3 | Fail | 3 |
| C | 8 | Fail | 3 |
Data Table
