If nested Function or any other function which can repeat process again and again

Hi,

I have Two columns in

Column A Name of Persons)
M
N
O
P


Column B:
10
50
40
50
20
50

Now I want a solution in such a way that when sum total of values in Column B >= equals to 60, then in front of that column value " M " displays and this process repeats till all the remaining values in column "A".

Result would be like that :

Column B : Column C :
10 ........... M
50 ........... M
40 ........... N
50 ........... N
20 ........... O
50 ........... O

It would be great if someone will provide solution to this problem.

Hi,

Sorry for replying late. Have tried this but it is not working, showing error. I am attaching sheet so it would give you better idea, what I am looking for.

In C1 input "A" (first name)

In C2 use

Please Login or Register  to view this content.

Copy down. See attached

In C2 use

Please Login or Register  to view this content.

copy down