EXAMPLE:
Row2 A2:12 B2:25 C2:36 D2:48 E2:56 G2:56
Row3 A3:1 B3:0 C3:1 D3:2 E3:4
Row2 shows 5 different numbers
Row3 relates to the Row2 number, Row 3 is the number of times Row2 number has hit.
I'm looking for a formula which picks the "highest" hit number (Row3) and places the appropriate Row2 number in the G2 cell.
This would be an automatic update since hits per number increase over time.
Thanks for the help...
Bookmarks