Get the correct Manager using excel formulas

[albert28]

Hi Guys,

i have attached a dummy file to get their correct Manager.

for example agent number "46030" have 4 entries and i need to get their correct manager by the last entries in column D and put the formula in Col E.

Thanks,

[:) Sixthsense :)]

In F2 Cell

=LOOKUP(2,1/($A$2:$A$10=A2),$D$2:$D$10)

Drag it down...

[albert28]

Super thanks !!!