Unplanned
Last Updated: 31 Jul 2025 10:57 by Jonas
Jonas
Created on: 31 Jul 2025 10:57
Category: SpreadProcessing
Type: Feature Request
0
SpreadProcessing: Add support for SEARCH function with dynamic arrays

SEARCH function with the following format is valid only in Excel 365/2021 or later (with dynamic array support).
"=SEARCH({"Alpha","Beta","Gamma","Delta","Omega","Sigma","Zeta"}, "Omega")"

• It returns an array of numbers or errors, showing the position of each substring in "Omega".
• If a substring is found, you get its position (e.g., 1 for "Omega"); if not, you get #VALUE!.

0 comments