Hi all thank you for taking a look at my problem.
Attached, I have a sample spread sheet that includes 4 columns. Customer Name, Profit, Gallons and Codes. In the spread sheet I am working with I have around 900 customers.
I want to see how many times a specific code such as "62" appears. I would also like to generate a unique list of codes with sum the total profit and gallons for each unique code. Any suggestions?
If possible I would like to output the data in format found in Sheet2.
Bookmarks