Excel 2019 and 365 New Functions that You Must Use.
You can easily combine cells values with or without delimiter, get the maximum or minimum value based on certain criteria, perform IF condition with multiple logical tests and without nested IFs, and lastly you can switch between values based on your own criteria. New functions are:
CONCAT
TEXTJOIN
MAXIFS
MINIFS
IFS
Switch
Add more than 100 new functions and features into your Excel using our powerful tool Dose for Excel Add-In.
visit Dose for excel Add-In website:
https://zbrainsoft.com