Thursday, February 20, 2014

yogi_Compute Number Of Sales By SalesPerson From Whole And Split Sales And Create A LeaderBoard

                                         Google Spreadsheet   Post  #1540
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Feb-20-2014
post by T.J. Gullo (!category-topic/docs/spreadsheets/TsygZVJP7ls)
Tally cells across row based on frequency in another column

I have a fairly specific question, and I don't even know if it is possible to do what I am asking.

The sheet I am using is on the new spreadsheet platform.

I work in a retail industry, and I am trying to populate a sales leaderboard based on recorded sales in another sheet. I sequentially want each instance on a sales log to populate a square with a color (or a number and I can conditionally format the cell to change colors) on another sheet. To complicate things, I want the sheet to be able to differentiate between a full sale or a split sale.

Here is a dummy sheet that represents what I am asking:

Basically, for each instance that sale is recorded for a salesperson, I want the leaderboard to automatically populate itself.

Thanks in advance, I know this is quite complicated.