0

Filter Problem

Emmanuel Sandmann

January 21, 2021 09:55

None

Follow

Hi there,

i have a problem with a filter. It is not possible for me to create a "smaller than" filter on a fixed cell reference in the NL formula:

=NL("Zeilen";50067;"VK-Preis";"Artikelfamilie Code";$N6;"Debitornr.";"''";"Datenquelle=";"NAV Entwicklung";"Mandant=";"Biochem GmbH";"Mindestmenge";"<T6").

Best regards,

Emmanuel

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Marc January 27, 2021 17:01

  Try this:

  "<"&T6

• 0
  
  Cat January 29, 2021 23:31

  With fixed cell reference it should be "<"&$T$6

• 0
  
  Amy W February 01, 2021 22:00

  You can also try a direct cell reference to $T$6.

  Then in cell T6, enter <100 or whatever is currently in T6.