Hello
Please see attached example excel file which i made because that will make things a lot more clear.
I would like excel to calculate which person has for example 2 red crosses in a row, 3 red crosses in a row, 4 red crosses in a row.
So by the column People with 2X's in a row there should be John, Mark, Nathalie
In the column People with 3 X's in a row there should be John, Mark, Nathalie
In the column People with 4 X's in a row there should be John, Mark
I cannot get much clearer than this and i think the attached will make things more clear. I tried searching google but could not find what i was looking for.
Bookmarks