One guess, one play ...

The 2 data sets are assumed running in A1 and in B1 down, viz.:
In A1 down is: A, B, C, D, E, F, G and H
In B1 down is: A, A, G, G, G, G, and H.

Place
In C1:
=IF(AND(COUNTIF(A:A,B1),COUNTIF(B$1:B1,B1)<2),ROW( ),"")

In D1:
=IF(ROW()COUNT(C:C),"",INDEX(B:B,SMALL(C:C,ROW()) ))
Copy C1:D1 down to cover the max expected extent of data in col B. Hide away
col C. Col D should return the results that you seek -- if my interp is
correct -- with all results neatly bunched at the top
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wilchong" <u43231@uwe wrote in message news:835526aece2e1@uwe...
This is the first time I send the request to Office KB for the help in
Excel.
My problem is to find out one formula which can figure out the result
which
I want. There are two sets of data. The first set data is A, B, C, D, E,
F,
G and H. The second set data is A, A, G, G, G, G, and H.


The result which I want is when the first data is exist in the second
data,
the data will automatic appear in one cell.

For example, because there are 3 A in second set of data, therefore, only
one
A appear in first cell. The second cell will have G and the third cell
will
have H. I need an Excel formula to have this result!

Many thanks,
Wilchong.