Hi, I've searched for a solution on this forum but haven't been able to find anything. Thanks in advance if you're able to lend a hand =)
I'm trying to find the max value from Col1, Col2, and Col3. Once found, I want its corresponding/adjacent cell to be outputted.
Col1 Col2 Col3 Col1-ADJ Col2-ADJ Col3-ADJ Output
1960 1966 1968 B M P P
1966 1970 ? B D ? D
1966 1968 1975 C M P P
1982 1972 1969 C P L C
1967 1969 ? ? ? ? ?