Hello,

I am not clear with what you want help with, I don't see any formulas in your attached file.

Hi Mohamed,

Can't help you with all three questions, but fixed the last one. @Anders: I think he is looking for formulas and that's why they can't be found in his sheet. The questions are in the sheet.

Mohamed: I splitted the cells back to normal in your columns I and J and put a MIN and MAX (with conditions, don't know how they are called in English, but you'll find them in the cells). That'll do.

There is a trick for your other two questions, I saw recently on  Sumit Bansals website (Trump Excel), but can't remember how to do it. Maybe you can look yourself there, or somebody here helps you.

Good luck!

Frans

Try this

Part 1

In cell F3 enter =IF(COUNTIF($B$3:B3,B3)=1,MAX($F$2:F2)+1,"")

Part 2

In cell G3 enter =IF(B3<>B2,MAX($F$2:F2)+1,G2)

Copy the formulas downward.

Hope this helps

Sunny