79260063

Date: 2024-12-07 06:23:36
Score: 0.5
Natty:
Report link

If I understand what you are trying to say, you want to get the id number of the second highest manager assigned to any given employee? If so, just count the number of ids assigned to the given employee and return the second last one:

=INDEX(D3:M3,COUNT(D3:M3)-1)

enter image description here

Reasons:
  • Probably link only (1):
  • Low length (0.5):
  • Has code block (-0.5):
  • Contains question mark (0.5):
  • High reputation (-1):
Posted by: Michal