For all: Just a friendly internal contest at my work this week - guessing an ending balance of our month-end accounts for this month.
Trying to determine who is the closest guess to the actual balance. My Excel 2010 spreadsheet has the following items, headers in row 2, and information below that:
Column A: Employee Name
Column B: Employee's Guess
Column C: Absolute difference between their guess and the actual.
I've Conditionally formatted column C to highlight the "bottom 1", and tested it to make sure that it highlights both items if there is a tie between the "over by" and "under by" the exact same amount. I have a named range-ActualBalance - for the actual ending balance.
I was hoping someone here could assist me with a formula in a cell that would automatically populate the cell with the winner(s), so I don't have to glance down the list manually.
Thanks in advance for all input, and have a wonderful Easter weekend!
Trying to determine who is the closest guess to the actual balance. My Excel 2010 spreadsheet has the following items, headers in row 2, and information below that:
Column A: Employee Name
Column B: Employee's Guess
Column C: Absolute difference between their guess and the actual.
I've Conditionally formatted column C to highlight the "bottom 1", and tested it to make sure that it highlights both items if there is a tie between the "over by" and "under by" the exact same amount. I have a named range-ActualBalance - for the actual ending balance.
I was hoping someone here could assist me with a formula in a cell that would automatically populate the cell with the winner(s), so I don't have to glance down the list manually.
Thanks in advance for all input, and have a wonderful Easter weekend!