Hi there,
Funny one this... easy to explain, perhaps, yet a bit tricky when asked how to solve it! Can anyone help me?
I have 2 columns.
Column A is data, for example a name Nigel, Greg, Betty.
Columb B is a number, besides 'Nigel' will be 3, next to Greg, perhaps 2, Betty has a 5 next to her name, etc.
I want to have a list somewhere else that is being populated by writing out the long-hand version of this data, so it would write:
Nigel
Nigel
Nigel
Greg
Greg
Betty
Betty
Betty
Betty
Betty
With each name repeated by the number, and in a new cell, thanks to someone's previous help I have this sort of working (but I can't attach the file
), but now I'd like it to do the following... can anyone help adjust the formula?? 
A) Can the formula be adjusted to not display a name at all if a zero is present next to a name?
And an even trickier one...
B) Within the list of names that grows, can there be pre-determined cells to skip?
For example if column D was the big list of names using your formula, could I have previously specified that D39 (and some other specified cells) must be skipped?
So that if I needed 5 x Graham, and it occupied D36, D37, D38, D40, and D41? Because I didn't want it to overwrite what I'd already written in D39.
Thank you so much to anyone that can help, in any way.
Funny one this... easy to explain, perhaps, yet a bit tricky when asked how to solve it! Can anyone help me?
I have 2 columns.
Column A is data, for example a name Nigel, Greg, Betty.
Columb B is a number, besides 'Nigel' will be 3, next to Greg, perhaps 2, Betty has a 5 next to her name, etc.
I want to have a list somewhere else that is being populated by writing out the long-hand version of this data, so it would write:
Nigel
Nigel
Nigel
Greg
Greg
Betty
Betty
Betty
Betty
Betty
With each name repeated by the number, and in a new cell, thanks to someone's previous help I have this sort of working (but I can't attach the file
), but now I'd like it to do the following... can anyone help adjust the formula?? A) Can the formula be adjusted to not display a name at all if a zero is present next to a name?
And an even trickier one...
B) Within the list of names that grows, can there be pre-determined cells to skip?
For example if column D was the big list of names using your formula, could I have previously specified that D39 (and some other specified cells) must be skipped?
So that if I needed 5 x Graham, and it occupied D36, D37, D38, D40, and D41? Because I didn't want it to overwrite what I'd already written in D39.
Thank you so much to anyone that can help, in any way.
