Range formula

SRAMAN Posts 2 Registration date Saturday October 10, 2015 Status Member Last seen October 21, 2015 - Oct 21, 2015 at 12:09 AM
Dear all

In MS excel column B is names of more than 100 staffs,column A is date of payment, column C is bill No (RA No 1-20), column D is amount billed, Now I want to see last payment date of each staffs.
What is the formula for this.