Advanced Filter to combine multiple entries into one totaled entry

[shill88]

Hi,

Im making a Spreadsheet inside excel to track my stock portfolio. What
I'm trying to do is make a Database in Excel where I enter all my
transactions for example:

SYM SHR PRC
DIS 100 $24
IBM 200 $86
DIS 100 $26

Then using this the Advanced Filter feature it automatically Sorts out
all like symbols Sums the total shares and averages stock price. I have
gotten to the point where I enter all the data and have advanced filter
sort it out and copy results to my portfolio page but it shows the
multiple entries rather than the one totaled entry. I know this would
be better served in an Access Database but its for a Microsoft Excel
class's Final Project so I'm stuck using excel.

Thanks for any help,
shawn

 

[Andy B]

Hi

I would suggest having a look at using a pivot table (Data / Pivot Table),
or maybe subtotals (Data / Subtotals). This might be what you are looking
for.