Hi,

I have a worksheet for students fees collections.

A1: Student Number
B1: Student Name
C1: Fees (amount) collected
D1: Fees for which month? (number 1604 for April 2016)

When fill Column A with the Student Number, Student Name in Column B is
getting updated by a vlookup formula. I also want Column D (fees for the
month) updated by increasing the previous highest value for the same
student by one. If the previous highest value for the same student in
column D is 1602 (February 2016), I want 1603 to appear in column D for
the current payment.

Any ideas?

TIA
Ahmed

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus