Anomandaris
03-24-2009, 04:36 AM
Hi guys,
just when i thought i had it all done, i'm told i need things in a different format.....so here's what I'm trying to do
I will have data similar to the one on Sheet1, and I need to send it to another sheet and look like Sheet2.
Lot means quantity
The codes basically represent months, eg Z8 is December 2008, H9 is MArch 2009.........so I need to first separate the trades by product, then by Buy/Sell, then by month Code......showing all the different individual trades by lots,price, (lot*price), then showing the total and average price for each monthcode.
Way too complicated for me to figure out, as there are so many products and number of trades vary here, I've only given example of 3 or 4 for each month but it could be 100. Also there could be several monthcodes for each product.
I got my fingers crossed. If you guys can help, it'd be awesome!
Thanks in advance, and i apologize if it wastes too much of your time.
just when i thought i had it all done, i'm told i need things in a different format.....so here's what I'm trying to do
I will have data similar to the one on Sheet1, and I need to send it to another sheet and look like Sheet2.
Lot means quantity
The codes basically represent months, eg Z8 is December 2008, H9 is MArch 2009.........so I need to first separate the trades by product, then by Buy/Sell, then by month Code......showing all the different individual trades by lots,price, (lot*price), then showing the total and average price for each monthcode.
Way too complicated for me to figure out, as there are so many products and number of trades vary here, I've only given example of 3 or 4 for each month but it could be 100. Also there could be several monthcodes for each product.
I got my fingers crossed. If you guys can help, it'd be awesome!
Thanks in advance, and i apologize if it wastes too much of your time.