Custom sort rows

[ToddLegere]

Each week i receive a spread sheet with many rows and columns of data.

Im only interested in about 10 rows scattered throughout the sheet.

In column "W" I scan and look for the rows I require. Im looking for words like MNBS and MNBC... Each row has a Key work that pertains to me.

It there a script that I can make that will search the column "W" each week for words I look for, then just show me these rows.

IE.. ( i don't know code so gone laugh) Get Row W MNBS,MNBC...

Thank you

Todd

[jason.b75]

No script needed, you can do that with advanced filter.

https://support.office.com/en-us/art...ad=US&fromAR=1

If the words you're looking for in column W are only part of the string in the cell, then you will need to use wildcard criteria, for example

="=*MNBS*"

[ToddLegere]

Thank you ...

[ToddLegere]

In my blank rows I can do the following

Row 1 Cel W ="=MNBC"
Row 2 Cel W ="=MNBS"

and it filters great.

How can i now just put then into just one command i.e.

Row 1 Cel W ="=N=MNBC" AND "MNBS"...

is this possible?

[jason.b75]

You could only do that if you wanted to filter rows that contain both strings (that is both in the same row).

In that case the best way would depend on an additional criteria as well.

If you want to filter for rows that contain both strings in a specific order, for example, show rows where MNBC is before MBNS in cel W, but hide rows where MNBC appears after MBNS then you would need to use something like ="=*MNBC*MNBS*"

If you wanted to show rows that contain both in any order, then you would need to use the AND criteria method shown in the link.