Hi Experts, Please refer the attached workbook.
The first sheet here "Schedule" gives the training requirements and Training batches, and the second sheet "Training Planner" needs to be updated based on this. I need a formula to be entered in "D4" that will give me the results as show in the "Training Planner" sheet. The formula should be such that we should copy across and down to give the results as shown. Thanks in advance. -- Thanks & Regards, Rahim Sharieff -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Training Planner.xls
Description: MS-Excel spreadsheet
