Why shouldn't Mary's 67.2 not be updated to 45?
All other entries are doubled.
This is not possible. Sometimes it is the last record that should be set to 0, sometimes the (two) first:
Phillip | MIAMI | Oct | 70,4 | 0 |
Phillip | MIAMI | Oct | 70,4 | 0 |
Phillip | MIAMI | Oct | 70,4 |
That can only be done manually.
Do you have any key field (record number) in your table? Can we add it?
Normally this a somewhat easy case except of the one with the "PHILIP" entry as mentioned by Gustav...which kind breaks the rules..
I prepared a small application that takes care of it..and it functions in all cases besides the order in "PHILIP"
take a look (the results are put in Goal2 field)
Your sample file has zero lengh. Please, uplad it again an show there expected result