Hi!

Try this array formula by entering with the key combo of
CTRL,SHIFT,ENTER:

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=1,ROW
($A$1:$A$10)),ROW(1:1)))

Replace the "1" in the IF function with whatever the
repeated value from col A is or use a cell reference.

You can find every Nth value by copying down. If you only
want to find the specific Nth value just change the 1:1 in
the second ROW function to the Nth value you want to find.
Example: 3:3 for the 3rd value.

An alternative would be to use a reference cell to hold
the Nth value you want to return. For example, in C1 you
enter 3 to return the 3rd value:

=INDEX($B$1:$B$10,SMALL(IF($A$1:$A$10=1,ROW
($A$1:$A$10)),ROW(INDIRECT("A"&C1))))

Biff

-----Original Message-----
Is there any formula to find the different
(1st,2nd,3rd...) values in column
B(B1:B10) corresponding to repeated values in column A
(A1:A10),without
creating another column?
.