Position of Last Specific Text Item in a Column

[SDruley]

Have a column

A B
1 SELL
2
3 BUY
4
5
6
7 SELL
8
9 BUY
10
11
12 SELL

I want to find the position of the last BUY (9) or the last SELL (12). The empty cells are "".
Thanks for any assistance. An array formula will also be acceptable.

[rcm]

=MATCH("SELL",B:B,1) and =MATCH("BUY",B:B,1)

[SDruley]

Thanks, rcm. It appears that I was incorrect in the original post. The blank cells contain "". When I use your formula as follows:

Please Login or Register  to view this content.

I get the last cell (row number) in shadowsBS which is a blank ("") cell, but when I remove the "" entries I get the correct answer. I would rather not remove the "" cells as this is a time consuming step.

[Marcol]

This will return the row number of the last instance, regardless of any other data or blanks in column B.

Please Login or Register  to view this content.

[SDruley]

Thank you gentlemen for your guidance and thank you Mr. Marcol for your innovative solution.

[icestationzbra]

with your data-set above:

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.