Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Excel advanced functions
Resolved · High Priority · Version 2010
Lisa has attended:
Excel Intermediate course
Excel Advanced course
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.
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
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.
Thu 20 Dec 2012: Automatically marked as resolved.
|
|
Excel tip:Removing custom dictionary entriesIf you add something to the custom dictionary in Excel you cannot remove it. The way to get around this is to go into word and remove it there. |
TrustScore
4.9
/ 5
2224 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
