EXCEL with what function formula to find all the records that meet the conditions? No need to filter

As said on the first floor, the formula will be slow, you can use filtering, text filtering, containment, not.

But the formula can also be, F2 in the input

=OFFSET(E $ 1,SMALL(IF(ISERR(FIND(E $ 1,E $ 2:E $ 30878)),4 ^ 8,ROW($ 2:$ 30878)-1),ROW(A1)),) &""

Simultaneous presses of CTRL+SHIFT+Enter, enter the array formula, and drop down with the autofill handle.

The formula will be slow, if you want to make it faster, you can check F2:F2500 (whichever is the most that will show up), and in the edit field, type

=OFFSET(E$1,SMALL(IF(ISERR(FIND(E$1,E$2:E$30878)),4^8,ROW($2:$30878)- 1),ROW()-1),)&""

At the same time, press CTRL+SHIFT+Enter, enter the array of multi-cell formula, so you can let the formula is only executed once, to improve the speed of some of the operation.

How much is a year's tuition at Eton School in Shiyan

What's the difference between an ordinary accelerator and an advanced accelerator for online games in Xun You?

Guiyang pinyin

Today's headlines don't want to see how to do one thing.

How about the joint training project of the Advanced Computing Industry-Education Integration Innovation Center?

What are the trends in big data innovation?

Gas detector top ten brands

As an example, what are the interaction data in big data

Where can I see the SF Express number?

Will the intersection of Cizhouzhai Expressway yield on September 6th?