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

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" wrote in message
...
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

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.
"Ron Coderre" wrote:

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" wrote in message
...
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