software

Hi,

I have a list of data like this:

John 12
18
11
Mary 56
23
67
etc etc

I am trying to fill john's name down next to all his figures and then mary's
name down all in one go.

I have tried selecting the range of names, hitting F5, selecting blank
cells, and then typing quot;=a1(in this case, john)quot; and then doing Ctrl, shift,
enter to fill the array. However, this fills down for John but stops at mary
and doesn't go any further down the list.

Is there anything I can do?

Thanks,

Mike

Hi Mike,

Select the cells in the first column, starting with the first data cell
(John) down to the last required cell

F5 | Special | Blanks | OK | Type =
Press the up arrow | Ctrl-Enter.
---
Regards,
Norman
quot;mike_vrquot; gt; wrote in message
...
gt; Hi,
gt;
gt; I have a list of data like this:
gt;
gt; John 12
gt; 18
gt; 11
gt; Mary 56
gt; 23
gt; 67
gt; etc etc
gt;
gt; I am trying to fill john's name down next to all his figures and then
gt; mary's
gt; name down all in one go.
gt;
gt; I have tried selecting the range of names, hitting F5, selecting blank
gt; cells, and then typing quot;=a1(in this case, john)quot; and then doing Ctrl,
gt; shift,
gt; enter to fill the array. However, this fills down for John but stops at
gt; mary
gt; and doesn't go any further down the list.
gt;
gt; Is there anything I can do?
gt;
gt; Thanks,
gt;
gt; Mike
Nice one, norman, thanks!

quot;Norman Jonesquot; wrote:

gt; Hi Mike,
gt;
gt; Select the cells in the first column, starting with the first data cell
gt; (John) down to the last required cell
gt;
gt; F5 | Special | Blanks | OK | Type =
gt; Press the up arrow | Ctrl-Enter.
gt;
gt;
gt;
gt; ---
gt; Regards,
gt; Norman
gt;
gt;
gt;
gt; quot;mike_vrquot; gt; wrote in message
gt; ...
gt; gt; Hi,
gt; gt;
gt; gt; I have a list of data like this:
gt; gt;
gt; gt; John 12
gt; gt; 18
gt; gt; 11
gt; gt; Mary 56
gt; gt; 23
gt; gt; 67
gt; gt; etc etc
gt; gt;
gt; gt; I am trying to fill john's name down next to all his figures and then
gt; gt; mary's
gt; gt; name down all in one go.
gt; gt;
gt; gt; I have tried selecting the range of names, hitting F5, selecting blank
gt; gt; cells, and then typing quot;=a1(in this case, john)quot; and then doing Ctrl,
gt; gt; shift,
gt; gt; enter to fill the array. However, this fills down for John but stops at
gt; gt; mary
gt; gt; and doesn't go any further down the list.
gt; gt;
gt; gt; Is there anything I can do?
gt; gt;
gt; gt; Thanks,
gt; gt;
gt; gt; Mike
gt;
gt;
gt;