I'm stuck on how to do these formulaes

Right am doing a spreadsheet and need help with some formulaes (if possible to do)

1) I want a cell to find the highest number in the row, then display the name at the top of the column.

2) I have a list of averages and I want the cells below each average to display the position the average is. The averages will change so want a formula to calculate the positions. If nned be I could write the position.

Any help or pointers would be great. Don't really know what to google for regarding these 2

1.Assuming you want to find the highest number in A6:J6 and return the corresponding header from row 1

=INDEX(A1:J1,MATCH(MAX(A6:J6),A6:J6,0))

If there are ties for maximum value this will just display the first header

2. What do you mean "position". If you want the highest number to be 1, the next highest 2, etc. then investigate the RANK function

Both correct with the first problem.

RANK sounds like the answer. Will play and post if it doesn't work

Thanks

Yes RANK seemed to be the answer. Thank you very much people