Count number of cells until reach the first occurrence of a specific value.

[Holmes12]

Hi There,

I have a row of cells containing text and I need to count the number of cells backwards through this range until I reach the first instance of a specific text. There will be more than one occurrence of this needed text and only the number of cells before the first appearance is required.

Thank you in advance.

 

[V620898]

Why vb formulas are given for excel users