i have six cells with six names . each cell (with its name) has got a value in a near cell.
for example (consider each letter is a cell and each number/value is a cell):
a 1
b 2
c 3
d 4
e 5
f 6
i want to find a function that writes, in another cell, the name of the cell whose near cell has got the highest value.
in the case above, it would be "f".
i don't know if i explained myself well
thanks for any help !
Bookmarks