Date function expanded
Hi Ahmed,
Am Thu, 21 Apr 2016 13:09:35 +0530 schrieb ahmed:
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.
if you have done the entries for the first month enter following formula
into the next row and modify the the range (at the moment the formula is
written for row3):
=MAX(IF($B$2:B2=B3,$D$2:D2))+1
Insert the formula with CTRL+Shift+Enter
Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional
|