+ Reply to Thread
Results 1 to 7 of 7

date wise move of cell value of one column to another column

  1. 03-10-2013, 01:49 PM #1
    abid1142
    abid1142 is offline
    Registered User
    Join Date
    03-10-2013
    Location
    faisalabad, pakistan
    MS-Off Ver
    Excel 2007
    Posts
    5

    date wise move of cell value of one column to another column

    hi frnds
    actually i want to move cell values of a column A to another column B with respect to C column the column C has date from 2002 to 2010 in it on daily bases day by day........the problem is that i have a data which is missing values in column A like 18,20,25 and 30 of January 2002(column C) has 2 3 0 1.1 now the task is how can i shift this value to column B in-front of date column C that 2 value automatically goes to date 18-jan-02 and 3 in-front of 20-jan-02.......
    please i need it hard
    please
    regards
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 03-10-2013, 02:10 PM #2
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: date wise move of cell value of one column to another column

    From what I can tell from a picture, you could try this in C2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    drag down

    The range $I$2:$J$25 may have to be adjusted, row 25 is all I could see in the pic

    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post
    Reply With QuoteRegister To Reply
  3. 03-11-2013, 07:01 AM #3
    abid1142
    abid1142 is offline
    Registered User
    Join Date
    03-10-2013
    Location
    faisalabad, pakistan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: date wise move of cell value of one column to another column

    hey twilightwolf!!!
    but its not working at all... it display #N/A.... please can u explain the failure em trying to dead but the formula is not adjusting
    the highlited table is for lookup, u bro got it??? and the value in column J is i like to move in column D where the date matches of column I and A
    please another suggestion from u is near nice to feel
    regards
    Reply With QuoteRegister To Reply
  4. 03-11-2013, 09:57 AM #4
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: date wise move of cell value of one column to another column

    Maybe if you upload a sample workbook we can get it resolved..it's near impossible to guess based on a screenshot
    Reply With QuoteRegister To Reply
  5. 03-12-2013, 08:09 AM #5
    abid1142
    abid1142 is offline
    Registered User
    Join Date
    03-10-2013
    Location
    faisalabad, pakistan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: date wise move of cell value of one column to another column

    hey
    herez i have the original work book on which em working
    and i've showed the problem...
    regards
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 03-12-2013, 10:52 AM #6
    dredwolf
    dredwolf is offline
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: date wise move of cell value of one column to another column

    Try this in D2:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    Drag down as far as necessary, don't go to far, or you'll overwrite your existing data towards the bottom of the column

    In the attached, I have put the formula in column L (yellow highlighted) for comparision

    Hope this helps
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 03-13-2013, 08:43 AM #7
    abid1142
    abid1142 is offline
    Registered User
    Join Date
    03-10-2013
    Location
    faisalabad, pakistan
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: date wise move of cell value of one column to another column

    hey twilightwolf..
    thanks a lot man you r really genius......excel expert
    warm regards
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1