A system of export excel file, of which the column "E" data information for the city, use commas between several cities (such as E5 cell is shown as "shenzhen, guangzhou, suzhou, Shanghai"), we should filter conditions on column "E", the screening data, such as display only city contains data line of the "guangzhou" or "Shanghai", consult everybody if there is a good solution to the great god, (note: the excel files by the system automatically export a every day, have to say data filtering work for once a day, can have a long-term solution? Thank you very not,)

CodePudding user response:

A custom filter

CodePudding user response:

Upstairs positive solution, this is the easiest way to the

Don't trouble you can also use advanced screening