Hi there.
I'm trying to make a spreadsheet in numbers on my iPad. The main sheet is on sheet 2, and on sheet 1 is a summary sheet.
On sheet two I have some names in column A, and points in column B. Have a look below:
Trine 56
Niclas 34
Thomas 75
On sheet 1 (the "summary sheet") I want to display the highest score, AND it's associated name. Find the highest score is easy, I just use the maksa (in Norwegian, it's called max in excel) function, and it finds the highest score, and outputs it's. but how do I find it's associated name in column A, and outputs this name to a cell on sheet 1 ?
I'm trying to make a spreadsheet in numbers on my iPad. The main sheet is on sheet 2, and on sheet 1 is a summary sheet.
On sheet two I have some names in column A, and points in column B. Have a look below:
Trine 56
Niclas 34
Thomas 75
On sheet 1 (the "summary sheet") I want to display the highest score, AND it's associated name. Find the highest score is easy, I just use the maksa (in Norwegian, it's called max in excel) function, and it finds the highest score, and outputs it's. but how do I find it's associated name in column A, and outputs this name to a cell on sheet 1 ?