Hello -
I applied a conditional formula =SUMPRODUCT(--ISNUMBER(SEARCH(Fortune_List,B2)))>0 to my list and I believe it worked. However, my first list has 45000 rows in it so I can filter by color to check and make alterations to the list.
? How can I filter by color, 45,000 rows?
Thank you