All,
I have a master sheet with a timestamp (column A) and a product (column C). I would like to have a formula that spits out the day in which the most of a given product ("MS") were sold. This is in a GoogleDoc spreadsheet as well so I would like to keep the formula to a minimum. I know I could create a giant table with every day and the number of products sold, then do a max on the product sold column, then do a vlookup on that to find the date. But the table would just get too big if we are looking at a year or so.
Example:
11/1/2012 MS
11/1/2012 MO
11/1/2012 MS
11/1/2012 MS
11/2/2012 MS
11/2/2012 MS
11/3/2012 MS
Record Day: 11/1/2012
MS Sold: 3
Bookmarks