34 Indexing formula? Wanting to see how to possibly use an indexing formula base

Question

34 Indexing formula?

Wanting to see how to possibly use an indexing formula based off the one below. I am using this formula to place an asterisk in the cell next to some names in an adjacent column if they show "review" in the text for column "M". Now that I have the asterisk there, I would like to have them listed at the bottom of the spreadsheet. So in summary, how can I get just the text in column M that contains "review" in the text to be grouped together at the bottom of the sheet?

Thanks!

=IF($M2="","",IF(ISNUMBER(SEARCH("*review*",$M2)),"*",""))

Explanation / Answer

(*If you * are in column N, Enter the below formula as Array Formula i.e. not by pressing ENTER after entering your formula but by pressing CTRL+SHIFT+ENTER. This will put { } brackets around the formula which you can see in Formula Bar. If you edit again, you will have to do CTRL+SHIFT+ENTER again. Don't put { } manually.

Drag down the formulas for other values.?>@#

=IFERROR(INDEX($M$2:$M$100, SMALL(IF("*"=$N$2:$N$100, ROW($N$2:$N$100)-ROW($N$2)+1), ROW(1:1))),"")

Related Questions

Navigate

• Browse (All)
• Browse 3
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.