Hi Team,
I am looking for some help in getting the prior day data by compare with today's data table...refer the below two data set and help in formula to achieve the same..thank you
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
End of the day in day 2 I need prior data column values by comparing the project and its probability
Let me know if you need further clarification. Thank you
I am looking for some help in getting the prior day data by compare with today's data table...refer the below two data set and help in formula to achieve the same..thank you
Day 1 Data | Day 2 Data | ||||
Project | Probability | Project | Probability | Prior Day | |
AA | 30 | AA | 30 | 30 | |
BB | 40 | BB | 60 | 40 | |
CC | 30 | CC | 40 | 30 | |
CC | 50 | CC | 80 | 50 | |
CC | 60 | CC | 100 | 60 | |
DD | 20 | DD | 20 | 20 | |
EE | 40 | EE | 40 | 40 | |
FF | 60 | FF | 80 | 60 | |
FF | 70 | FF | 90 | 70 | |
GG | 30 | GG | 50 | 30 | |
GG | 40 | GG | 90 | 40 |
<colgroup><col span="4"><col><col></colgroup><tbody>
</tbody>
End of the day in day 2 I need prior data column values by comparing the project and its probability
Let me know if you need further clarification. Thank you