Hi Michelle
You're welcome!. Thank for the feed back.
kk
"Michelle Wong" wrote in message
...
Hi kk
Thanks a lot for your help! It works! :))
cheers
Michelle
"kk" wrote:
Hi Michelle,
I assume your data in A1: B8 and Bin array in F2:I2 (1,5,8,10)
To return the Unique Person Name:
Enter this array formula in E3:
=IF(ROWS($E$2:E2)<=SUMPRODUCT(($A$2:$A$8<"")/COUNTIF($A$2:$A$8,$A$2:$A$8&"")),INDEX(A2:$A$8,MAT CH(0,COUNTIF($E$2:E2,A2:$A$8),
0)),"")
Confirmed the formula by Ctrl + Shift + Enter and drag down.
Copy this formula,
=TRANSPOSE(FREQUENCY(IF($A$2:$A$8=$E3,$B$2:$B$8,"" ),$F$2:$I$2))
Select F3 till I3 and hit F2, and paste the formula by using Ctrl+V.
Confirmed the formula by Ctrl + Shift + Enter and drag down
It will return the result as needed.
Attached is the sample file.
http://savefile.com/files/8267872