how to use the automatic ranking process (excel) with autoit?

[Peggy]

 

 initially I will receive excel file in the following figure

His class species is divided into two categories: Fruit and Fruit-AB
When the re-ranking process, the first group of the first search Fruit and Fruit-AB first group, but because the first two groups are all Apple, so Fruit-AB group automatically search the next, and in the next column to make a X, shown below.

 

So such a rule, after the completion of the following figure.

I would like to ask each for how to coding? Thank you very much !!!!

[water]

Can you please show us what you have tried so far? What doesn't work? Any errors you get?