have a look at the help index for INDEX

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pete" wrote in message
...
I'm trying to reference the actual row number that a maximum value appers
in.
This is what i'm trying to input but does not work =row(max(array))
.So if over a certain array, what is the row that that maximum value
appers
in.