Advanced Filter Challenged

Topic

New Reply

I’m having a challenge with an Advanced Filter; specifically the criteria.

I have attached a sample file with the expected results highlighted in green.

Thanks for taking a look,
John

Reply | Quote

Replies

Set your criteria to only F1:F2

F1 should be blank (since F2 will have a formula)
F2 should have:
=NOT(ISBLANK(B2))

Steve

Reply | Quote

Set your criteria to only F1:F2

F1 should be blank (since F2 will have a formula)
F2 should have:
=NOT(ISBLANK(B2))

Steve

Hi Steve,

I tried your suggestion without success. The end result of your suggestion lists all the items and does not pare down the information to what I have highlighted in green.

Regards,
John

Reply | Quote

You probably haven’t followed Steve’s instructions entirely correctly. See the attached version.

Reply | Quote

You probably haven’t followed Steve’s instructions entirely correctly. See the attached version.

Sorry, my error as I did not leave F1 blank as instructed by Steve. All is well.

Thanks Steve and Hans,
John

Reply | Quote