J
John Jacks
Dear All
this is a tricky one, well at least for me
I have to determine out of three vehicle dealers who sold each particular model vehicle for the highest value and then have put into 1st, 2nd and 3rd place for each model. This needs to be done on a number of vehicle models and registration years etc
I was thinking of using a pivot table, showing the model on the left, then the customer, then the Max sale price in the data but how can I take this information so that a user can select a model and it shows whose 1st, 2nd and 3rd placed at selling for the highest value
Needs to be extract by Model Plate Dealer Max Sale price .
this is a tricky one, well at least for me
I have to determine out of three vehicle dealers who sold each particular model vehicle for the highest value and then have put into 1st, 2nd and 3rd place for each model. This needs to be done on a number of vehicle models and registration years etc
I was thinking of using a pivot table, showing the model on the left, then the customer, then the Max sale price in the data but how can I take this information so that a user can select a model and it shows whose 1st, 2nd and 3rd placed at selling for the highest value
Needs to be extract by Model Plate Dealer Max Sale price .