Dear Excel Masters,
Please refer attached SS Maint sheet.xls I am looking for formula to bring the correct value under yello field "Previous Balance".
Excel should pickup previous balance under particular heading like if i am in December, 2016, it should pick up Previous balance under that colum group (column group means/ i.e. Total due this Month, Previous Balance, Payments, Balance, Interest @21%......), if i am in january, 2017 colum group, it should pick up December 16 Previous balance.
it will be a great help.
Thanks and Regards,
Hrushikesh
Bookmarks