"Biff" wrote in
:

Hi Ashish!

Here is a link to a modified version of your sample file:
multiple_results.xls

multiple_results(modified).xls 21.0 kb

http://cjoint.com/?hkdJZirhGq

The formula I have used is significantly shorter and is more
efficient. I would highly recommend you adopt this method.

Biff


{=IF(ROWS($1:2)<=COUNTIF(A$3:A$9,A$11),INDEX(B$3:B $9,SMALL(IF(A$3:A$9=A
$11,ROW(B$3:B$9)-ROW(B$3)+1),ROWS($1:2))),"")}

Prior to checking back, I did manage to find a 3yr old post to another
Excel group that answered my question. However, I will definitely say that
your method is much shorter and involves one less cell than what I got from
that old post.

Even with my photographic memory, I still wonder how in the world I'm going
to remember how to make the above formula work with future worksheet
designs. So I'd better do the smart thing and save your post (and modified
version of Ashish's file) for future reference.

Thanks a bunch to all of you for the quick and helpful responses.



Scott