You can either use AutoFilter to select all the abc's or the technique
described in:

http://office.microsoft.com/en-us/ex...260381033.aspx
--
Gary''s Student - gsnu201002


"GWM" wrote:

I have a table of names with corresponding amounts as follows:
Note: I prefer using functions and not code for this project.

A B
abc 1000
def 5000
ghi 3000
abc 4000
def 7000
abc 9000

Example: I need to retrieve all of the "abc" names and the amounts, and
place the amounts in 3 consecutive cells, which correspond to "abc."
The range is dynamic, with a maximum of 15 rows, 5 different names (in
column A), and 3 amounts per name.
Thank you in advance for your help