Iterations of a function

[Mortadella]

I have a label in cell A2 and a number in B2

If A2 says "George" and B2 says 3 I want to be able to have three lines on another sheet with George in A1, A2, and A3


Similarly five rows if B3 (or whatever row I have) has 5


It sounds easy but I can't figure out how to do it.

 

[NARAYANK991]

Hi ,


A similar question has been asked in the past , and Chandoo provided a solution , which is available here :


http://chandoo.org/forums/topic/looking-for-a-formula-as-an-alternative-to-vba-based-solution-10


I think you can adapt it to your problem.


Narayan

 

[Mortadella]

Many thanks