Use formula to get "B" Break Time for each agent in the first column-CodePudding

Home > Software design > Use formula to get "B" Break Time for each agent in the first column

Use formula to get "B" Break Time for each agent in the first column

Time：08-01

CodePudding user response：

try in row 7:

 =INDEX(TRIM(FLATTEN(QUERY(TRANSPOSE(IF(E7:R="B"; E6:P6; ));;9^9))))