scottlarock
Board Regular
- Joined
- Apr 10, 2009
- Messages
- 102
Hello all,
I have a db on sheet 2 from
A1:AC100000
with product names and associated customer names along with prices and margins, quantity etc..
On sheet 1, I have just about the same thing with different values, but without the customer name.
So according to the product name A2:A100000,
and the country B2:100000,
I would like to return the customer name on sheet 2 with the highest price 'sheet2'F2:F100000, margin 'sheet2'G2:G100000 etc..
I have other conditions such as, returning the customer with the biggest price and margin difference between in 2011 to 2012... but I think the top part will do for now...
Tons of thanks in advance for your help !
Btw, how do you "copy paste" excel into here to ease the explanation a bit... ?
Scott
I have a db on sheet 2 from
A1:AC100000
with product names and associated customer names along with prices and margins, quantity etc..
On sheet 1, I have just about the same thing with different values, but without the customer name.
So according to the product name A2:A100000,
and the country B2:100000,
I would like to return the customer name on sheet 2 with the highest price 'sheet2'F2:F100000, margin 'sheet2'G2:G100000 etc..
I have other conditions such as, returning the customer with the biggest price and margin difference between in 2011 to 2012... but I think the top part will do for now...
Tons of thanks in advance for your help !
Btw, how do you "copy paste" excel into here to ease the explanation a bit... ?
Scott
