Hi,
Can somebody guide me how I can go about doing this? I can do it with VBA but I don't want to use macros. Is there a way to do it only with formulas.

If I fill first few rows of column A with consecutive numbers (say 1,2,3,4), the column B should get populated as 1,1,1,2,2,3.
If it is 5, then 1,1,1,1,2,2,2,3,3,4

I couldn't succeed at doing this

Thanks