Forum Discussion

CN_xing's avatar
CN_xing
Copper Contributor
Sep 04, 2024

新函数TRIMRANGE似乎有点问题

当我尝试用LET和LAMBDA函数进行简化的时候，发现他不会完全展示而是只限制左上角的值，看上去像是加了一个@符号

 

 

 

excel

2 Replies

Sort By
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    Apr 26, 2025

    Try to use any other name for lambda-based function. T() is build-in function in Excel, during the evaluation of your formula some conflicts appear.

  • MarilynMonroe's avatar
    MarilynMonroe
    Iron Contributor
    Apr 25, 2025

    Check whether the second parameter exceeds the data range, and then check the syntax difference between the English and Chinese versions of the formula, if not, try to use the combination of FILTER + TRIM to realize similar functions.

Resources