Initials / Code / Supplies / Catering / Per Diem / Trans / Hotel / Tips
11-Oct BAP / SNA / / / $36.00 / /
/ $5.00
25-Sep GWB / LAS / / / $36.00 / /
/
11-Oct JAD / IAD / / / $36.00 / /
/ $10.00
11-Oct JLL / SNA / / / $36.00 / /
/ $5.00


Of course my spreedsheet is much larger, but as an example, I want to know
how much is goes to BAP. I normally have more than one row for each set of
initials and the amounts are normally in more than one column. I remember
doing something like this before, but it has been about 10 years.

Thank you for letting me pick your brains. I have been trying to solve this
for 2 hours