HI, PFA.
Regards, MARIES. On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey <resp...@gmail.com> wrote: > Hi Oxford Excel Gurus > > In the fill attached sheet "P&L" i have been able to write a formula that > can show how many number of years i want to view the report ie if i want to > see 5 years report i will select from the drop down, and so forth. and the > number o years specified will show > > In the 2nd sheet ie "P&L (2)" I have also written a formula to view which > year the report should begin from say year 2007 , or 2008 etc. > > the problem is how to combine these two formulae into one when i can have > a situation where i can select a particular year to view the report and > specify how many years from there to view the report. > > kindly help with a formula. tx > > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > > > ------------------------------------------------------------------------------------------------------ > To post to this group, send email to excel-macros@googlegroups.com > -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
Annual Report.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
