What would you do if two teams have the same high score for the week?

"Andrew" wrote:

> 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.