Hi All Excel Masters,
While comparing two columns in the Excel sheet...
If i have identical values in range B1:B10 in sheet 2 i have to get fetch first value at first search and second value at second search respectively. ie My Column B in sheet 1 will surely be having the same two identical values.

Example,
Sheet 1 Column B is
a
b
c
d
d
e
f
g
h

Sheet 2 Column b is
b
h
d
e
g
d
f
a
c

The fourth row 'd' should be matched with third row 'd' and fifth row 'd' should be matched with sixth row 'd' respectively. both 'd's from sheet 1 should not get matched with third row 'd' itself in sheet 2.

Thanks In Advance