return row for nth occurrence of text in array

[Greg777]

<SOLVED>

Hello,

I'll appreciate any help received. I've attached a small Excel 2007 document to demonstrate what I am trying to do and to provide data to ground a discussion.

I'd like to sort column A and return the row number for the first occurrence of the letter 'a' formulaically (B1). In B2 second cell, I'd like to return the row number for the second occurrence of 'a', and so forth.

So far I have not come up with a satisfying way of doing this and have not been able to find a post that has accomplished it. I've managed to do everything else without VBA so far, and would like to keep it that way if possible. I've tried combinations of Row(), Match(), Vlookup(), Countif(), and Indirect().

Thanks!


Greg