Needing help finding a formula/function to use for this situation:
I am holding a photo contest. There are 3 different types of photos people may turn in for this contest, so I have made 3 different worksheets to display scores. However, I want to see each person's HIGHEST photo score in one sheet at the end of my workbook so I can award the high-point winner quickly and easily.
I have tried to do a =MAX(sheet1:sheet3!:L2) function, but it tells me I have an error in the NAME? of the cells I have selected.