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
Bookmarks