HI,

I was hoping someone could help me with the following formula:

In column A I have start times, column B end times and in column c I have case names. I am trying to compare the content of column c to a constant cell containing the case name in a different location in the spreadsheet. If they match I would like the value of column A to be added in a list. It might be easier to explain if you look at the s/s attached.

Underneath the case name Monkey I would like it to display the start time. For this the first would be 12:30 then 13:48 and so on and so forth, but I don't want it to display any of the TEST times, I want those to appear under test and so on and so forth.

Any help would be really appreciated. Book1.xlsx