CHANGELOG

CHANGELOG (21 May 2018)

  • XFLOOKUP now supports string swaps.
  • Percentage similarity algorithm was upgraded.
  • Changed error display codes.
  • The lower limit for threshold is now 0.
  • 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 called ZFLOOKUP for horizontal lookups.
  • Improved handling of large tableArray ranges (100+ rows or 100+ columns).

CHANGELOG (08 October 2018)

  • Added a new function called 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 highlighting duplicate values or deleting rows with duplicate values is now 1.

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.

CHANGELOG (25 July 2019)

  • Added a new function called ULIST for returning unique values from a specified range.

CHANGELOG (15 September 2019)

  • Upgraded ULIST to return data from more than one column.

CHANGELOG (29 September 2019)

  • Added an option to subscribe for premium features.
  • Added helpful error messages.
  • Upgraded core Flookup engine with speed and accuracy.

CHANGELOG (15 October 2019)

  • Upgraded FUZZYMATCH for faster execution speeds.