On Dec 7, 1:07 pm, OldMac77 wrote:
Hello,

I have a spreadsheet with many children and their club dues. (It is
not very orderly.)
Names are in range B12 to B208 and their payments are in range F12 to
F208.
How can I write a formula that would create a list of all payments
made by "Brian Gumbs" .in another part of the spreadsheet?

eg
Brian G $23
Brian G $25
Brian G $50

(Windows XP, Excel 2003)

Thank you all,

OldMac

Hi
Have you tried using a Pivot Table?
I'll assume your data table has headings called Name and Payment.
Click in your table of data and do Data, Pivot Table and
Pivot Chart Report. Click Next. Click Next again. Choose where you
want the
table. In Layout drag Name to the Row area and Payment to the Data
area. Click Finish. The values in Data are the total payments broken
down by Name.
To see the data rows for Brian G, double click his total payment and
you will get a new sheet with Brian's details on.
To update the table as you add names, right click the table and click
on Back. Select the new data Range and click Finish.
regards
Paul