Hello,

I want to get the following:

B C
John
Maria
Nelson
John 1
Alex
George
John 4

In other words: I need an formula on Cx that display the row number of last occurence of text in Bx prior to Bx.

Can anyone help me?