Get location of the first occurence & last occurence of value in a set of duplicate entry

Hi -

I have a set of names in column A, it is listed alphabetically and names are duplicated several times, in column B is the list of all names... I want to get the location of both the first and last occurence of each names listed in column A base on the names in column B and select the entire row.

Please see attached file for reference. Thank you...

Hudas

You could use the formula:
=MATCH(B1,A$1:A$23,0) in cell C1 and =MATCH(B1,A$1:A$23,1) in cell C2 and copy them down for each row in b1:b3.
Of course the same thing can be done with macro.

Regards,
Antonio

I get the idea.. Thank you very much! have a good day!!