Skip to content

Find Query In Column & Find Query In Row Should be Merged Into One Function  #7

@physics515

Description

@physics515

Proposed name: Find Query

Input

  1. Worksheet Search Worksheet
  2. Range Search Range
  3. String Search Term
  4. Integer Search Algorithm
    1. 1 Quick Search (Uses Excels build in find function. Works quickly but does not always return the correct value.)
    2. 2 Accurate Search (Uses Excels build in find function. If no result is found, falls back to Brute Force Search. A middle ground for accuracy and speed.) Default.
    3. 3 Brute Force Search (Loops through every cell in the range and manually compares the values, Returns the first matched cell. Slow but always gets the job done.)
    4. 4 Return Something Search (Uses Accurate Search, If nothing is returned, falls back to Fuzzy Search)
    5. 5 Fuzzy Search (Uses common.fuzzySearch to return the closest match cell.)

Output

Variant - Integer Array (ex. [column, row]), If nothing is found the function will return [0, 0]

Metadata

Metadata

Assignees

Labels

enhancementNew feature or request

Projects

No projects

Relationships

None yet

Development

No branches or pull requests

Issue actions