Hi Mr.Biff,
I have tried.But I am not getting the result correctly.In one example,first
value/text is got,for 2nd,3rd,...values ,same value is showing.In some
example error message #value! or #REF! is shown.After entering the formula,I
have pressed CTRL,SHIFT,ENTER.I have only 2 columns(A1:A10 ) &(B1:B10) in the
example.Whether the formula is applicable for values(both numbers & texts) in
column A & B.
Thanks in advance
K.S.Warrier

"K.S.Warrier" wrote:

Thanks a lot Mr.Biff
K.S.Warrier


"Biff" wrote:

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?
.