Countif's

[shapirja]

Hi,

I am using a Countif with a range of one row and a simple text criteria.

I would like to write a formula that pulls the last occurrence of that text criteria in that row down to another row in the same column.

Is this possible?

If so, any formula suggestions?

Thanks

JS

 

[Domenic]

Can you provide a small sample of the data, along with the expected result?