Hi,
- Experiments are performed over 3 days. Dates are in column A.
- Each day has 10 numbered experiments. Experiments’ numbers are in column B.
- Each experiment has outcome expressed in %. Percentages are in column C.
- Each experiment has threshold which is fixed for all experiments and expressed as % in cell: B2.
- =IF() function evaluates if experiment reached threshold or not. Outcomes are in column D.
What I’m trying to do is have a function (after googling-ing and chatGPT-ing it, it was suggested to use =COUNTIFS ), that shows ONLY the first instance when threshold was reached each day. So in the example on the screenshot I want column D to look like column E.
