| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data
data won't repeat names in column. example
A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data
Select column A and F5SpecialBlanksOK
Type = sign in active cell then point or arrow to cell above. Hit CTRL + ENTER to insert formulas with the missing names. You can then copy column A and EditPaste SpecialValuesOKEsc to get rid of the formulas. Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 20:07:00 -0800, Karel wrote: data won't repeat names in column. example A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data
hi
what method are you using now that isn't working? regards FSt1 "Karel" wrote: data won't repeat names in column. example A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data
just copy down manually. too large to do that.
"FSt1" wrote: hi what method are you using now that isn't working? regards FSt1 "Karel" wrote: data won't repeat names in column. example A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data
Is there any way to automate so I don't have to do this with every new data
run? "Gord Dibben" wrote: Select column A and F5SpecialBlanksOK Type = sign in active cell then point or arrow to cell above. Hit CTRL + ENTER to insert formulas with the missing names. You can then copy column A and EditPaste SpecialValuesOKEsc to get rid of the formulas. Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 20:07:00 -0800, Karel wrote: data won't repeat names in column. example A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
data
Record a macro whilst doing the steps.
Gord On Tue, 4 Dec 2007 08:21:01 -0800, Karel wrote: Is there any way to automate so I don't have to do this with every new data run? "Gord Dibben" wrote: Select column A and F5SpecialBlanksOK Type = sign in active cell then point or arrow to cell above. Hit CTRL + ENTER to insert formulas with the missing names. You can then copy column A and EditPaste SpecialValuesOKEsc to get rid of the formulas. Gord Dibben MS Excel MVP On Sun, 2 Dec 2007 20:07:00 -0800, Karel wrote: data won't repeat names in column. example A1=my name B1-B13 various data for me A14=your name B14-B23 various data for you how do I get my name in A2-A13 and yours in A14-A23? it's never the same names or rows of data. Thank you very much! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MULTIPLE DATA - How to insert new data into existing data.... | Excel Discussion (Misc queries) | |||
Linear Mode
