Not quite sure about how you want to apply it....

so...
Maybe something like:

This formula returns the Row Number of the cell containing the first instance of the max column value:

=MATCH(MAX(A:A),A:A,0)

Does that help?
Is that something you can work with?