Product Ideas

Share your suggestions and ideas. Vote on ideas you find valuable.

Add capability to filter Excel data used as table source for NL function

You can define an Excel range or named range as a table source for the NL function, but there is no way to filter on that range. By parsing the number of columns in the table range, you could expose an implicit fields list ColA, ColB, ColC, etc and then filter within the appropriate column as an offset. If the NL table is defined with a named range, then the name range name could be used and would implicitly point to ColA. 

Actually, since the columns are relative to the range, the implicit list should probably be named something like RangeCol1, RangeCol2, ..., RangeColN to avoid confusion with sheet range that was selected.

  • Gary Winey
  • Jul 20 2017
  • Under Consideration