Recent

« previous next »
Pages: [1]

Author Topic: Bug in the formula MATCH  (Read 452 times)

veb86

  • Jr. Member
  • **
  • Posts: 92
Bug in the formula MATCH
« on: February 07, 2025, 07:28:39 am »
Match typeBehaviorDetails
1ApproximateMATCH finds the largest value less than or equal to the lookup value. The lookup array must be sorted in ascending order.
0ExactMATCH finds the first value equal to the lookup value. The lookup array does not need to be sorted.
-1ApproximateMATCH finds the smallest value greater than or equal to the lookup value. The lookup array must be sorted in descending order.
(omitted)ApproximateWhen match_type is omitted, it defaults to 1 with behavior as explained above.

The type - 0 is not working correctly. It shows the last result of the entry, but it should be the first one.
Logged

wp

  • Hero Member
  • *****
  • Posts: 12682
Re: Bug in the formula MATCH
« Reply #1 on: February 08, 2025, 12:02:49 pm »
Fixed in r9621
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018