Lisa has attended:
Excel Intermediate course
Excel Advanced course
Excel advanced functions
Please find below our Profit analysis report, is there some clever formula, to:
•YTD report to pick up revenue from column V of all monthly tabs using departmental codes in column B and showing in column E in YTD report.
•Column V will remain as revenue in all monthly tabs.
•We have used THREED functions before for this report but it is not working in Excel 2010.
•We do not want to use Vlookup function and then add manually each month.
there is no facility to attach the spreadsheet here but am happy to send it by email.
RE: Excel advanced functions
Hello Lisa,
Hope you enjoyed your Microsoft Excel courses with BEST STL Training.
Thank you for your questions regarding your profit report.
Please would you email your attachment for my attention to info@stl-training.co.uk and we can take a look at your questions.
Kind regards,
Richard
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
