+ Reply to Thread
Results 1 to 6 of 6

Excel 2010 vs Current Version

  1. #1
    Registered User
    Join Date
    02-17-2017
    Location
    London, Ontario
    MS-Off Ver
    2010
    Posts
    8

    Excel 2010 vs Current Version

    I am currently on Excel 2010 and would like to know the function library differences between that and the current version (what functions the current version has that the old one does not). Where can I find a list of this?

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Excel 2010 vs Current Version

    Why not simply search...? You'll find all the information you need without someone having to list them out for you.

  3. #3
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,858

    Re: Excel 2010 vs Current Version

    Since I happened to have the page pulled up for other reasons, here's the list I use most often. https://support.office.com/en-us/art...90033e188#bm14 New functions introduced in 2010 or later versions are indicated.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Excel 2010 vs Current Version

    I am using Professional Plus 2016 ver 1703 build 7967.2139 and it does not have many of the new 2016 functions. Below are just a few
    concat()
    ifs()
    maxifs()
    minifs()
    switch()
    textjoin()
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  5. #5
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Excel 2010 vs Current Version

    re: textjoin()
    NOTE: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.

  6. #6
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,946

    Re: Excel 2010 vs Current Version

    Quote Originally Posted by tim201110 View Post
    re: textjoin()
    NOTE: This feature is only available if you have an Office 365 subscription. If you are an Office 365 subscriber, make sure you have the latest version of Office.
    None of teh above are available on the desktop version of 2016, but all (I believe) are available on 365 (and Mac, I think) boo hoo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Current version macro will work or not in future version
    By Sekars in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2016, 09:59 AM
  2. Formulas not working in higher version, 2010 Version to 2013 version
    By thilag in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-19-2015, 09:09 PM
  3. Get code that works on excel version 2007 to work on version 2010
    By Agent1 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-21-2014, 01:23 AM
  4. Hi, i'm almost completely new to Excel, i am using version 2010
    By jeffberrill in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-30-2013, 07:25 PM
  5. Default Fit To Selection for all Excel 2010 Version..
    By suryatry26 in forum Excel General
    Replies: 0
    Last Post: 07-15-2013, 05:47 AM
  6. current vba addon version for excel
    By IO Xavier in forum Excel General
    Replies: 1
    Last Post: 06-07-2011, 08:02 AM
  7. Excel 2007 to 2010 version problem
    By Gundersen in forum Excel General
    Replies: 0
    Last Post: 03-31-2010, 09:01 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1