My Data table looks like this:

Product Rep Price1 Price2 Diff
A Jim 30 42 12
A Bob 35 42 7
A Stan 40 42 2
A Bill 45 42 3
A Ed 50 42 8
B Jim 15 28 13
B Bob 20 28 8
B Stan 25 28 3
B Bill 30 28 2
B Ed 35 28 7
C Jim 1 7.5 6.5
C Bob 2 7.5 5.5
C Stan 3 7.5 4.5
C Bill 4 7.5 3.5
C Ed 5 7.5 2.5


I am trying to create this table:

Product Rep
A Stan
B Bill
C Ed

This new table lists each Product, and identifies the Rep that has the
smallest "Diff". If there is a tie, it is not that important which rep is
listed but I only need one listed. The actual data table has on average
40,000 rows - if that makes a difference on the approach for a solution.

Is it possible to do this with VBA and/or excel formulas ?

Thank you in advance.