Forum Discussion

John_White690's avatar
John_White690
Copper Contributor
Sep 08, 2023

Finding partial entries from one list

HI!    I'm having the following issue and can't figure out what would be the best the way to resolve it.   I have column A that has file names such as   12345alt1.png 12345alt2.png 12345alt3....
excel
Formulas and Functions
OliverScheurich's avatar
OliverScheurich
Gold Contributor
Sep 08, 2023

John_White690 

=IF(SUMPRODUCT(N(ISNUMBER(SEARCH(B1,$A$1:$A$200000)))),"","not in column A")

You can try this formula.

John_White690's avatar
John_White690
Copper Contributor
Sep 08, 2023
Hey! thanks for the reply, sorry I had made some mistakes in my original post and wasn't as clear as I could have been. I edited the post to include more information. Sorry about that.
  • OliverScheurich's avatar
    OliverScheurich
    Gold Contributor
    Sep 08, 2023

    John_White690 

    =IF(SUMPRODUCT(N(ISNUMBER(SEARCH(LEFT(A1,5),$B$1:$B$3)))),"","not in column B")

    For .png which start with 5 numbers you can apply this formula.

     

Resources