Hi guys,
I am sitting on this for a long time now and hope somone can help me. Please find ma file attached.
What I need in column F is the following:
- look at Pers no (A)
- look at Month/Year (C)
- in dependence of these two, take each value from column D once and sum column E
Result is a single PersNo should have one Value per Month.
I hope this is somewhat clear.
Please find the file attached.
Thanks a lot!
Bookmarks