+ Reply to Thread
Results 1 to 6 of 6

What's New and Improved in Office 2016 for Office 365

  1. #1
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    What's New and Improved in Office 2016 for Office 365

    For those who maybe interested, the recent update to Microsoft Office 2016/Office 365 has delivered a few new and very useful function for Excel.

    MAXIFS and MINIFS -- these two functions use the same syntax as other IFS functions

    CONCAT function that replaces CONCATENATE can take ranges but has no delimiter.

    TEXTJOINT a totally new concatenate function that takes ranges, uses delimiter and takes an argument of TRUE/FALSE (1,0) for empty cell.

    SWITCH somewhat similar to CHOOSE.

    and IFS function

    MAXIFS function

    =MAXIFS(K2:K5,K2:K5,"<400")

    v K L M
    1
    2 414 78
    3 34
    4 78
    5 35

    MINIFS function

    =MINIFS(K2:K5,K2:K5,"<400")

    v K L M
    1
    2 414 34
    3 34
    4 78
    5 35

    CONCAT function

    Although as I mentioned earlier CONCAT function doesn't have a delimiter option, I was able to use it as an array formula

    =SUBSTITUTE(TRIM(CONCAT(IF(A2:A8={2,4,7}," "&B2:B8,"")))," ",", ")

    v A B
    1
    2 1 Sunday
    3 2 Monday
    4 3 Tuesday
    5 4 Wednesday
    6 5 Thursday
    7 6 Friday
    8 7 Saturday
    9
    10 Monday, Wednesday, Saturday

    TEXTJOIN function

    =TEXTJOIN(", ",1,B2:B8)

    v A B
    1
    2 1 Sunday
    3 2 Monday
    4 3 Tuesday
    5 4 Wednesday
    6 5 Thursday
    7 6 Friday
    8 7 Saturday
    9
    10 Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday

    SWITCH function

    =SWITCH(D2,1,SUM(G$2:G$5),2,SUM(I$2:I$5),3,SUM(K$2:K$5))

    v D E F G H I J K L
    1 Sum ranges range 1 range 2 range 3
    2 1 147 25 65 414
    3 2 270 32 45 34
    4 3 561 45 145 78
    5 45 15 35

    IFS function

    =IFS(A1<5,1,A1<10,2,A1<15,3,TRUE,4)

    v A B
    1 1 1
    2 5 2
    3 10 3
    4 3 1
    5 2 1
    6 4 1
    7 6 2
    8 7 2
    9 12 3
    10 15 4

    For more details:

    https://support.office.com/en-us/art...f-bca4603e1426
    Last edited by AlKey; 03-11-2016 at 06:26 PM.
    If you like my answer please click on * Add Reputation
    Don't forget to mark threads as "Solved" if your problem has been resolved

    "Nothing is so firmly believed as what we least know."
    --Michel de Montaigne

  2. #2
    Forum Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: What's New and Improved in Office 2016 for Office 365

    To update your Office 365/Office 2016:

    Got to File, Select Account, Click on Update Options, Update Now. Your update will be completed in few minutes.

  3. #3
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,701

    Re: What's New and Improved in Office 2016 for Office 365

    Sounds good and thanks for sharing the info

    I love to here the Concat() function arrival but just wondering why no Split() function?


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,391

    Re: What's New and Improved in Office 2016 for Office 365

    As already posted (I am using 2016 Pro Plus)...
    hmm my updates are set to automatic, and when I tried to manually update, it saw i was already up to date
    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 Guru AlKey's Avatar
    Join Date
    07-20-2009
    Location
    Lakeland, FL USA
    MS-Off Ver
    Microsoft Office 2010/ Office 365
    Posts
    8,903

    Re: What's New and Improved in Office 2016 for Office 365

    Do you also have a Office365 subscription?

  6. #6
    Forum Expert JapanDave's Avatar
    Join Date
    06-10-2008
    Location
    The grid, I got in!
    MS-Off Ver
    Excel 2010/13
    Posts
    1,696

    Re: What's New and Improved in Office 2016 for Office 365

    Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
    I am the real 'Napster'
    The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...

    If you receive help please give thanks. Click the * in the bottom left hand corner.

    snb's VBA Help Files

+ 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. [SOLVED] VBA on Office 2016 for Mac
    By pclaesen in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 2
    Last Post: 03-21-2016, 05:06 AM
  2. Replies: 1
    Last Post: 01-31-2016, 07:46 AM
  3. Update from Office 97 to Office Professional Plus 2016
    By billd73 in forum Excel General
    Replies: 0
    Last Post: 12-28-2015, 05:15 PM
  4. Default excel template in Office 2016?
    By honeybadger_rgr in forum Excel General
    Replies: 0
    Last Post: 12-10-2015, 12:19 PM
  5. [SOLVED] Implement office 2016 version
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-02-2015, 01:32 PM
  6. VBA error 3706 connecting SQL Azsure Office 2016
    By LotusElise in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-28-2015, 10:46 AM
  7. Office 2016 Is it worth Upgrading?
    By TwistedFaith in forum Excel General
    Replies: 0
    Last Post: 08-25-2015, 06:10 AM

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