what should i put in criteria if the data is blank? coz we have a list of items 22,542... 35% of this item have no date in purchase..
heres the link of picture..
<link removed>
what should i put in criteria if the data is blank? coz we have a list of items 22,542... 35% of this item have no date in purchase..
heres the link of picture..
<link removed>
Last edited by pbaldy; 03-14-2018 at 07:26 PM. Reason: removed link
Criteria to do what? if you want the blank ones, generally
Is Null
will work. By the way, attaching your image here will get more attention. Many of us won't follow links to unknown sites.
i've tried it.. thank u! for the quick response... u got it...
Code:GreatIDEA
No problem and welcome to the site by the way!