Forum Discussion
Solved
Formula to find current manager of staff by the lastest date
Hi guys , From table 1, I want to get the current manager of staff by the latest date as the screenshot below. Could you please help me with the excel formula? Thanks ! Best Regards, N...
=INDEX($C$2:$C$10,MATCH(LARGE(IF($B$2:$B$10=B2,$A$2:$A$10),1),$A$2:$A$10,0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
=INDEX($C$2:$C$10,MATCH(LARGE(IF($B$2:$B$10=B2,$A$2:$A$10),1),$A$2:$A$10,0))You can try this formula. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel 2021.
Thank you very much for your help OliverScheurich!