Using multiple criteria with a wildcard to return multiple values

[chrisou]

Hi Everyone

I am trying to use mulitple criteria including a wildcard to return all values which satisify the 3 criteria in the attached spreadsheet.

The formula in the spreadsheet is using INDEX, SMALL and COUNTIF and works provided that I enter in G4 the full text to be searched as a criteria. However, if I wish to enter a text string using a wildcard as in H4 the formula does not work..! I have text in column C which will not always be a full match but needs to be taken into account if a partial match.

I would really appreciate you help on this problem to return ALL time values in column B which satisfy the 3 criteria

Many thanks

Chris