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
Bookmarks