Hello there,
I am an expert in Excel as you would see in my work history here on freelancer. I have completed more than 475 excel projects with 'Excellent' ratings from clients across the globe. I reviewed the two files and the results you are looking for could be quickly created by use of formulas and macros.
If you could accept my bid, I would be able to get started and send the results back in 3-4 hours. I am clear on how the columns need to be calculated except Average DIS. Is it calculated based on difference between DateFirstListed and DateSold and then averaging the result for all items that were sold?
If you could clarify this, I would be able to get started right away.
Look forward to working with you and thank you for considering my bid.
Regards,
Rishi
Automyze Consulting - The Business Process Automation and Optimization Experts