DOES ANYONE HAVE ANY SUGGESTIONS?? I'M DESPERATE!!

I have a database like the one below (only with a lot more records). For each unique contact, I need to be able to pull the unique funds and unique programs which that person has. For example, I need to be able to pull the data and paste it to a worksheet column such that Jim Smith will show Funds 110, 250, and 900 and Programs 101 and 169. Same for the other "Contacts." I figure an array is the best way to do this but I am not that familiar with arrays. This also needs to be dynamic...the names in the Contact column could change, and the number of contacts could change as well. Any thoughts? Am using VBA (Excel).

Grant # Fund Program Contact
102365 110 169 Jim Smith
123645 250 169 Jim Smith
123697 110 183 Kate Johnson
265971 600 179 Bill Brown
265985 250 183 Kate Johnson
316495 250 160 Bill Brown
369855 110 236 Bill Brown
412365 250 236 Bill Brown
659784 900 101 Jim Smith
698531 110 119 Kate Johnson
965231 900 102 Kate Johnson


[Edited by ctfreel on 09-08-2000 at 02:48 PM]