 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Split list via every other cell.
Okay. I had someone show me what to do (on office 2003 I think) but I cannot get it to work on 2007. I have a list I am trying to split with every other number, odd and even. The list in column A is about 460 words. In column B, I was shown to do this.... cell B1 =$A1 cell B2 =$A3 He then used the CTRL key to select both cells and then drag down. What this did was a continuation of the odd numbers but let A appear before each number. When I use the CTRL key in Office 2007 and select both cells, I do not get the dark outline with the black dot at the bottom right that is supposed to be used from grabbing and dragging. I have alos tried the shift key which seems to select both but when dragging down does not do what this person had shown me. Stu The method you think you were shown in 2003 would not work in 2003 so maybe you saw something else. You would get =$A1 =$A3 =$A3 =$A5 =$A5 =$A7 =$A7 I would enter this formula in B1 and copy down to pick up every odd row value in column A =OFFSET($A$1,2*ROW()-2,0) BTW............if you are not seeing the "fill handle" for grabbing, it may be disabled in your "Edit" options. Gord Dibben MS Excel MVP >Okay. I had someone show me what to do (on office 2003 I think) but I cannot >get it to work on 2007. I have a list I am trying to split with every other [quoted text clipped - 11 lines] >key which seems to select both but when dragging down does not do what this >person had shown me. That's it!! Thanks! Now to really show my lack of skills. I also need the formula for the even numbers. What would I change? > Stu > [quoted text clipped - 36 lines] > >key which seems to select both but when dragging down does not do what this > >person had shown me. =OFFSET($A$1,2*ROW()-1,0) Gord >That's it!! Thanks! Now to really show my lack of skills. I also need the >formula for the even numbers. What would I change? [quoted text clipped - 39 lines] >> >key which seems to select both but when dragging down does not do what this >> >person had shown me. For the odd numbered rows enter this formula in B1: =INDEX(A:A,ROWS(B$1:B1)*2-1) For the even numbered rows enter this formula in C1: =INDEX(A:A,ROWS(C$1:C1)*2) Select both B1 and C1 and copy down as needed.  SignatureBiff Microsoft Excel MVP > Okay. I had someone show me what to do (on office 2003 I think) but I > cannot [quoted text clipped - 17 lines] > this > person had shown me. That did the same thing. Either way both you guys are great. Thanks for the help!! > For the odd numbered rows enter this formula in B1: > [quoted text clipped - 27 lines] > > this > > person had shown me. You're welcome. Thanks for the feedback! SignatureBiff Microsoft Excel MVP > That did the same thing. Either way both you guys are great. Thanks for > the [quoted text clipped - 33 lines] >> > this >> > person had shown me. Yet one more way.... For the odd numbered rows enter this formula in B1: =OFFSET($A$1,2*ROW(A1)-2,0) For the even numbered rows enter this formula in C1: =OFFSET($A$1,2*ROW(A1)-1,0) Select both B1 and C1 and copy down as needed. Rick > Okay. I had someone show me what to do (on office 2003 I think) but I > cannot [quoted text clipped - 17 lines] > this > person had shown me. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.