A
Andrew
I have 12 Sheets with essentially the same data on each one of them. The
sheets are named by Teams (I.E. Andrew, Will, Shon, Jack). On each sheet I
have the following information in each column (with column headers in the
first row).
A= Week
B= Opponent
C= Team Score
D= Vs. Score
E= Difference
F= W/L/T
What I would like to dois have a formula that would return the Name of the
Team and what week the Highest Score was. I already have the formula for
figuring the Highest Score, but I can't figure out how to make the cell next
to it return the Team or Week. Can someone help me out?
Thanks in advance.
sheets are named by Teams (I.E. Andrew, Will, Shon, Jack). On each sheet I
have the following information in each column (with column headers in the
first row).
A= Week
B= Opponent
C= Team Score
D= Vs. Score
E= Difference
F= W/L/T
What I would like to dois have a formula that would return the Name of the
Team and what week the Highest Score was. I already have the formula for
figuring the Highest Score, but I can't figure out how to make the cell next
to it return the Team or Week. Can someone help me out?
Thanks in advance.