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