0

Filter with equal og bigger than cell reference + blank?

Anders

December 21, 2022 09:40

None

Follow

I am trying to make an nl-function where i need to retract data for a certain date range. I would like to filter based on the date needs to be equal or bigger than a cell-reference but i would also like to include blanks. My problem is i don't know how to incude the blanks. Does anyone has a suggestion to a solution?

The formula is as follows (Danish):
=HVIS.FEJL(@NL("Første";"Købspris";"Købspris";"Varenr.";D7;"Leverandørnr.";E7;"Min. antal";"<="&I7;"+Købspris";"*";"Startdato";"<="&Options!$C$4); "")

It is the last part in bold i need to have adjusted to include blanks.

• Facebook
• Twitter
• LinkedIn

3 comments

• 0
  
  Cat December 22, 2022 08:11

  Without verifying it, I guess that would work: "<="&Options!$C$4&"|''"

  => | and two single quotation marks ''

• 0
  
  Anders December 22, 2022 10:54

  Hi Cat,
  
  Works perfect. Thank you for the assistance! :)

• 0
  
  CascadiaDataworks December 22, 2022 17:07

  And you can use @@ instead of "", just makes it easier to read.  I would also recommend using the .. format instead of >=.  I've seen times where Jet misinterprets the >=.  

  I would have it something like Options!$C$4&"..|@@" (says "from/including date in C4 and forward to the future or blank")