i confuse of doing this, A2=55 G2-G11=M5600, M1023, M1255, M5698, M8855, M7755, M8888, M6980, M4556, M10236 i want to extract all match data in index G1-G10 that contain number 55, so i get result in B2=M1255 ,C2=M8855 D2=M7755 E2=M4556, i use this formulaBut whit that formula i only get 1 match result in B2, how to get c2 d2 and e2 row result? please help mePlease Login or Register to view this content.
this is my example
Bookmarks