Excel help

Hello everyone,   I have some question for Excel. I wanna know if there is any tool or formula that can help me with this problem.   Below is the picture in workbook. On the left side, you can s...