I am trying to write a code that calculates the average price based on specific criteria. The lines will always change so it needs to be a general code that says for all the same account in column A, if the security in column C is the same, then average the prices listed in column K and place that number in column O.
Attached is a example of the sheet I am working with and how I want to average the price.
Reply With Quote