The TEXTSPLIT function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016, 2019 and 2021 versions. It works exactly as its original Microsoft counterpart. Description The TEXTSPLIT function splits a text string into multiple values using specified delimiters. The result is a dynamic array that spills into … Read more
The FILTERX function was introduced by Modern Functions Update (MFU) in order to allow users of older Excel versioni, namely 2007 and 2010, to use a function similar to FILTER. Thanks to FILTERX you can now use a very similar FILTER-like function close to its original Microsoft counterpart. FILTER was officially introduced with Excel 2021, but thanks to Modern … Read more
The FILTER function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2013, 2016 and 2019 versions. It works exactly as its original Microsoft counterpart. While older versions of Excel, 2007 and 2010, should use FILTERX instead. The FILTER function filters a range of data based on one or … Read more
The UNIQUE function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016 and 2019 versions. It works exactly as its original Microsoft counterpart. Description The UNIQUE function returns a list of unique values from a range or array. The result is a dynamic array that automatically spills … Read more
The XMATCH function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016 and 2019 versions. It works exactly as its original Microsoft counterpart. Description The XMATCH function searches for a specified value in a range or array and returns its relative position. It is the modern … Read more
The XLOOKUP function was officially introduced with Excel 2021, but thanks to Modern Functions Update (MFU) you can now run it on your Excel 2007, 2010, 2013, 2016 and 2019 versions. It works exactly as its original Microsoft counterpart. Description The XLOOKUP function searches a range or an array for a specified value and returns the corresponding value from another range … Read more