Advanced filter criteria

[Marvin Buzz]

How can I set up an advanced filter criteria to indicate that I want only
those rows that do not have an empty cell in a particular column?

EG:
LOGONS USERIDS LPAR
140 41 FMST
4 3 PRDW
282 95 PROD
26 11 SUDO
9 4 SYSP
242 62 TEST
703 216
I would like to filter out the last row in this case.
Thanks in advance.

Marvin Buzz

 

[Ron Coderre]

Could you use an AutoFilter?:

Using your posted sample data...

• Select A1:C8
• From the Excel Main Menu: <data><filter><autofilter>
• Click the dropdown arrow on the LPAR column (C1)
• Select: Nonblanks

Is that something you can work with?
Post back if you have more questions.

Regards,

Ron
Microsoft MVP - Excel

 

[Marvin Buzz]

No, I cannot use an autofilter. My intent is to programatically copy only
those records that meet my criteria to an alternate location, effectively
eliminating entries that are null. Using autofilter, I would need to
determine the number of entries in the filtered list, then copy them to the
alternate location.

After repeated tries to find appropriate criteria to accomplish my goal, i
found that using
<>
in the criteria field works. I enter it without quotes.

Thanks for your reply.