Team,

I have a question regarding automated formulas that can be utilized to simplify a large data set.

Essentially using the pivot table function, I have been able to summarize my required data to 20,000 lines.

What I need to do next is to identify the minimum/maximum sell price based upon the Item # sold at several different accounts. Next I need to identify the account where this was sold.

Can someone help me out? I have attached a sample data set of what I am looking for.

Thanks

Aravindexcelquery_1.xlsx