arrangement of different Cells, which need to be filtered out first

Hello Forum, i am very new and i would like to get a Problem solved with your help... so lets go for it: (please note, english is not my native language,)

in every Cell in one given Line i either have the cell filled with the number 1 or the number 2. Example below

A B C D E F G H I J K L M N..... till 100 (CV)
4. 1 2 1 2 2 1 2 1 2 1 1 2 1 1..... till 100 (CV)
5. 2 1 2 1 2 2 2 1 1 1 2 2 1 2..... till 100 (CV)

now, i would like to give a command to filter line 4, from left to right, and find a pattern, that appears first! (in the filled Cells (1 or 2))

for example.: Excel, should now look in 4th line from "A" to "C V" and mark the pattern that appears first. For example mark it red. if the 2nd pattern appears first, mark the second pattern for example yellow. ( i will upload an xls. doc with a small example so to make things more clear.)

so i need a function that tells Excel... to look in line 4 --> From file "A" till file "C V" which pattern appears first, and mark it either red or yellow.

Patterns:
First Pattern Formation to search in line : 1 2 1 2
Seco. Pattern Formation to search in line: 2 2 2 2

the pattern that appears first should be marked, so that it is clear which appeared first.

HOPE you can help me


Kind regards branko

note: basically its not important how to mark it, it just should recognize which "searched" pattern appears first, in the looked line (from left to right), and give a sign which one it was, doesnt matter if it marks red or yellow, its important to find it.

thank you very much for your answer and effort! the only thing is, for example, i want to have 100 (1-100) rows filled from "A" to "C V" with 1 or 2 , that is written in Cells..
and i would need a drag down function that marks out which combination appeared first in which row.

so if i fill a lot of cells with 1 or 2 . i want to drag over them and to can visually see when it appeared first time and which combination of 2 possible combination came up first.

for example i have the whole fiel with 1s and 2s filled. i want him to can drag down and mark the first wich appears. (1 2 1 2 against 2 2 2 2 ) now show me in every line which one appeared first and where it appeared first.

is that maybe possible?

THANK YOU FOR YOUR 1. ANSWER!

i made an excel sheet, where you can see all line with filled CELLS 1 and 2, and to find the first appearing sequence of the two given in every line ... and make some kind of a mark to see where it is.

i hope its clearer now (my vision)

KR, branko

wow

what a hero you r to me right nooow no joke! thanks 1000 times.

so my last question if i would wann search sequence 12121 and 22222
i just change the numer 1212 to 12121 AND 2222 to 22222 ? in the formula?

so i can try different two Formation against each other?

10.000 thanks! really cool

i could do it alone neede to make +4 and change 1212 to 12121 and 2222 to 22222

looks :

=UND(SPALTE()>=MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999)); SPALTE()<=MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999))+4; INDEX($A6:$CV6;MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999)))=2)

=UND(SPALTE()>=MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999)); SPALTE()<=MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999))+4; INDEX($A6:$CV6;MIN(WENNFEHLER(SUCHEN("12121"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999); WENNFEHLER(SUCHEN("22222"; TEXTVERKETTEN("";FALSCH;$A6:$CV6));999)))=1)


am i right? the graph looks good marked ))))))

THX

=AND(COLUMN()>=MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999)), COLUMN()<=MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999))+4, INDEX($A6:$CV6,MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999)))=2)

=AND(COLUMN()>=MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999)), COLUMN()<=MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999))+4, INDEX($A6:$CV6,MIN(IFERROR(SEARCH("12121", TEXTJOIN("",FALSE,$A6:$CV6)),999), IFERROR(SEARCH("22222", TEXTJOIN("",FALSE,$A6:$CV6)),999)))=1)


OK like that? KR

i tried 11212 and 11121 but its not working?
is there a need for which is put in first? and with 1 ? and with 2?

KRR

it is 11212 and 11121.

it doesnt take the second one, one works out but the second one not. ?
Hmm idk..

Attachment 728020

thanks i was looking for that ))) i dont know what that means, the main thing is i want to test a few pairs against each other. so i will try out :D thank you