How to filter the null records in filter by expression?

For example i have 50 columns i filter the nulls in FBE.in filter by exp a parameter select_exp .what function is used .how to write the condition .i take a example on emp file(empno,ename,sal......).how to write the condition in filter by expression?

Questions by madhu922.m   answers by madhu922.m

Showing Answers 1 - 3 of 3 Answers

SHIV

  • Dec 28th, 2011
 

You can use NOT ISNULL(empid).

  Was this answer useful?  Yes

shiv

  • Jan 2nd, 2012
 

IS NOTNULL(salary)

  Was this answer useful?  Yes

G

  • Jan 13th, 2012
 

U can use : " <>" to filter null values using code.
Eg:
with worksheet.range("A1:B10")
.autofilter 2, criteria1: "<>"
end with

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions