| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
How do I tackle this problem?
Using Excel07 ... I've got several thousands of lines like so:
A B C row1 joe blah1 date1 row2 date2 row3 bob blah2 date1 row4 date2 i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and so on ... |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I tackle this problem?
One possible way, select the ranges in A and B where you need to the
previous entry copied down so in your posted example select A1:B4, press F5, click special and select blanks, then type = and press up arrow once and finally press ctrl + enter After confirming it went OK select the range again and copy and paste special as values in place to remove the equal sign (aka formula) -- Regards, Peo Sjoblom "JayPee" wrote in message ... Using Excel07 ... I've got several thousands of lines like so: A B C row1 joe blah1 date1 row2 date2 row3 bob blah2 date1 row4 date2 i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and so on ... |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
How do I tackle this problem?
Forgot one thing
One possible way, select the ranges in A and B where you need to the previous entry copied down so in your posted example select A1:B4, press F5, click special and select blanks, click OK to select the blanks then type = and press up arrow once and finally press ctrl + enter .... One possible way, select the ranges in A and B where you need to the previous entry copied down so in your posted example select A1:B4, press F5, click special and select blanks, then type = and press up arrow once and finally press ctrl + enter After confirming it went OK select the range again and copy and paste special as values in place to remove the equal sign (aka formula) -- Regards, Peo Sjoblom "JayPee" wrote in message ... Using Excel07 ... I've got several thousands of lines like so: A B C row1 joe blah1 date1 row2 date2 row3 bob blah2 date1 row4 date2 i would like to populate A2 with A1, B2 with B1, A4 with A3, B4 with B3, and so on ... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
| anyone care to tackle this?? | Excel Discussion (Misc queries) | |||
| Best way to tackle this problem... | Excel Worksheet Functions | |||
| How to tackle Division by zero for DAVERAGE function | Excel Worksheet Functions | |||
| problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Linear Mode
