Below in the pic on the right side you have got the values. On the left the excel formula "count(And(A4=A5);1;0)" is included which counts how many times each value appears in a row. You see the value "2" and "8" appears twice in a row. The formule is however cumbersome. A more practical way would be to have a formula over the column which counts all values that are constant once in a row then twice in a row etc. Would be the "index" command a solution?
Aucun commentaire:
Enregistrer un commentaire