CHANGELOG

CHANGELOG (21 May 2018)

  • XFLOOKUP now supports string swaps
  • Percentage similarity algorithm was upgraded
  • Diacritical marks are now supported
  • Changed error display codes
  • The lower limit for threshold is now 0, down from 0.3
  • FUZZYMATCH now formats numbers correctly
  • Version numbering changed for consistency

CHANGELOG (28 May 2018)

  • Added support for comparing numbers with FUZZYMATCH
  • Added support for performing lookups for numbers with FLOOKUP

CHANGELOG (28 September 2018)

  • FLOOKUP can now return the nth best match
  • Major upgrade of FLOOKUP and XFLOOKUP algorithms

CHANGELOG (02 October 2018)

  • Added a new function ZFLOOKUP for horizontal lookups
  • Improved handling of large tableArray ranges (100+ rows or 100+ columns)

CHANGELOG (08 October 2018)

  • Added a new function RD for removing diacritical marks

CHANGELOG (16 October 2018)

  • Refined the percentage similarity algorithm to favour character sequences
  • Refined XFLOOKUP to respect string sequences e.g. "John Andrews" and "Andrews" are no longer considered to be the same

CHANGELOG (05 November 2018)

  • Added support for finding and highlighting duplicate values in single columns either by percentage similarity or similarity of sound (as pronounced in English)

CHANGELOG (13 November 2018)

  • Added support for deleting rows with duplicate values either by percentage similarity or similarity of sound (as pronounced in English)
  • The "Minimum percentage similarity" for finding duplicate values or deleting rows with duplicate values is now 1, up from 0.9

CHANGELOG (14 December 2018)

  • Significant speed improvements for highlighting cells and deleting rows with duplicate values

CHANGELOG (31 January 2019)

  • The FLOOKUP function can now allows ranges as the lookupValue parameter

CHANGELOG (14 May 2019)

  • The FUZZYMATCH function can now allow ranges as the string1 and the string2 parameter or as the string2 parameter only

CHANGELOG (10 June 2019)

  • The ZFLOOKUP function is now HFLOOKUP
  • The XFLOOKUP function is now SOUNDMATCH
  • The RD function is now LATINIZE

CHANGELOG (25 June 2019)

  • Functions for highlighting and deleting duplicate values have been upgraded

PLEASE SUPPORT US BY MAKING A DONATION TODAY

Facebook icon
Twitter icon