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
Bookmarks