Good day.
I am looking for a formula.
On excel I have to match number 1 2 or 3 with 13 numbers with commas in 500 rows.
Sample is the right line 1,3,1,2,2,3,1,2,3,1,1,2,1
What is the possibility to match it according to the row
Ex 1,3,1,2,2,3,1,2,3,1,1,2,1
To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1
The 2,2 is wrong
or
Ex 1,3,1,2,2,3,1,2,3,1,1,2,1
To show maybe 1,2,2,2,2,3,1,2,3,1,1,2,1 is right
Please help me
Solved by I. Y. in 21 mins