serach of dat

[M.K]

hi all

if i have the following coulma

file123 33 33 58
file124 23 34 36
file123.a 27 26 64
filees123 22 27 67
file345 23 44 36
file123 11 99 44


how i can make new sheet include the file which have 123 so result will be

file123 33 33 58
file123.a 27 26 64
filees123 22 27 67
file123 11 99 44

thank you

 

[Stefi]

Make sure you have a header in row 1, then Data>Autofilter>Select custom from
column A drop down list, choose Start with option with value "file123"

Regards,
Stefi

„M.K†ezt írta: