Need help summing quantities of numerous duplicate entries

Hi All,

I'm new here and have a question that may have already been answered and I just didn't know how to look for it. I am a financial consultant and have recently started my own firm. The ala carte menu at the new broker/dealer won't allow me to look at my total positions (for a given asset management strategy) as if it was a single account. That matters because I like to be able to look at the whole picture first before tackling individual accounts.

The software will allow me to export everything -- just not in any sort of order. For example, if I have 40 accounts who each own from 10 to 18 holdings, I get 500-600 rows with the security and the number of shares for every client in a particular strategy. I can delete unneeded columns and can sort the data alphabetically to at least get the security symbols in order. What I would like to be able to do is total the shares for each holding. If the total could be in a new column even better so I can get rid of the duplicate symbol entries by sorting the total column.

Here is what it looks like now after I've trimmed-out the unneeded columns:

Security Symbol Shares
FXL 2098
FXL 1094
IBM 318
IBM 298
IBM 400
RSP 2098
RSP 4676
AIVSX 12987
AIVSX 5471

A given security symbol could be repeated 40 times with different share amounts for each client who owns it.

I use several outside portfolio analysis programs that accept ASCII (comma delimited) data. If I can get this big report pared down to the total shares per position I manage, I can monitor my own performance and set alerts for moves I need to make.

Thanks for any help, Skip

Thanks Gents, Here's a piece of the master report. Ignore the Security column -- it is just in there for the bonds. I had to put this in an .xls format to attach it but you get the idea. If somehow the total for each position could be in another column, I can sort by the totals column and delete the individual positions. Thanks again, sh

Thanks for your reply. It was a long, hot weekend!

Yes, this is the sort of thing I need. Do you have a link to a place where I could learn to do this? sh