Two new functions in the Feb 2016 release of Office 365 are MAXIFS and MINIFS. These join the existing SUMIFS, COUNTIF, and AVERAGEIFS to let you find items that meet multiple criteria.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
The February 2016 release of Office 365 introduces four new functions. This video deals with the new SWITCH function.
In the Feb 2016 release of Office 365, a plural IFS function. No more nested IF statements, with one oddity where the old IF function used to have value_if_false.
Microsoft Marketing was more excited about the black theme than =TEXTJOIN()??? Who would like black Excel? Excel for Goths!
The February 2016 release of Office 365 includes new features such as partial matching on the function name as you start to type a formula.
Here is the beauty of Office 365 - the Excel team can push out updates between releases and the new version of Excel 2016 includes some killer functions - including TEXTJOIN that lets you concatenate a range of cells with a delimiter between each cell. Also covered here: the CONCAT function.
How can you use conditional formatting to highlight all formula cells? It is easier in Excel 2013 with ISFORMULA, but possible in previous versions with some VBA. Make a note in the comments if you previously new about Home, Find and Select, Formulas!
I've been annoyed by Compact Form in Pivot Tables since Excel 2007. I am sure you have things in Excel that annoy you as well. Now, you can communicate those annoyances directly to the Excel team using Excel.UserVoice.com.
In this live Dueling Excel podcast, you have to filter out a bunch of columns and filter rows by using MATCH or VLOOKUP. Bill solves this with an Advanced Filter. Mike solves it using amazing steps in Power Query.
