I need a formula to check column c that has ytr in any of it’s cells, if they do, then count matches in column e on same sheet, then input answer on another sheet, in same workbook.
A b c d e
GHN4 31/01/01 ytr 2001-11-08 2001-11-14
CROY 29/01/01 2001-10-24
CWH4 31/01/01 ytr 2001-11-08
WAN4 29/01/01 ytr 2001-11-16
The answer here would be one (1).
