Jump to content


Missing formula: Excel 2016 expert skills for windows pg 51 (Sidebar)


1 reply to this topic

#1 Guest_Jeannie_*

Guest_Jeannie_*
  • Guests

Posted 11 March 2017 - 12:48 AM

Hi There,

I just bought your Expert book and just started the course.  I came across a missing formula on page 51 under note at the very bottom.  Lesson 1-12: Convert a range into a table.

 

it is missing a formula  =SUBTOTAL(9,[Value])

 

Thank you.

Love the book.  I should have taken this course ages ago!

 

Regards,

Jeannie

 



#2 Mike

Mike

    Advanced Member

  • Administrators
  • 182 posts

Posted 11 March 2017 - 07:52 PM

Dear Jeannie

 

Thank you for taking the time to report this error.  The sidebar on page 51 had truncated the last time and you are correct, the formula that was truncated is = SUBTOTAL(9. [Value]).

 

This has now been corrected and will appear correctly in all future print runs of the book.

 

Best Regards

 

Mike Smart


Mike Smart is the author of ten world best-selling Excel books. The books are available in printed form for for Excel 2007, Excel 2010, Excel 2013, Excel 2016 for Windows and Excel 2016 for Apple Mac. Mike has also recorded over 850 video lessons (that you can watch online) for Excel 2007, Excel 2010 and Excel 2013.
Mike Smart is also part of the team that answers questions posted on the ExcelCentral.com forums.




Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users