Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to select all not null value on activate sheet please help me how can i achieve this.
PFA
Great it works,
Thank you Tresesco.
Wouldn't it be easier to user "*" as the Select In Field argument instead of the concat() expression? Or "?" if you wanted to exclude the blank?
-Rob
You are right Rob Wunderlich, however what I thought is there could be some blank values which appear to be null to the users and are not really so. To handle the case, I thought it would be better to use len(trim())>0.