I need Help : (

[alexoigres]

Hello everybody.

Maybe my question is really simple, but i have a column of data with 50,000 rows and i need to filter it with some criteria....like all the numers with L11, NT3, NPH, UA3, etc etc.

96657868 &AU3&APW&L11&UA5&C46&DG2/DBI&BAE
96657869 &AU3&APW&UA5&C66/C60&DG2/DBI

Who can i create a macro that just can give the numbers that contain my criteria?

Than you
SG

 

[Oaktree]

Welcome to the board.

You could do this without a macro...

In a new column, put =--SUM(--ISNUMBER(SEARCH({"L11","NT3","NPH","UA3"},A1)))

Filter the new column (data --> filter --> autofilter) for custom: does not equal 0