+ Reply to Thread
Results 1 to 9 of 9

formula to copy data from upper cell to down cell untill any change

  1. #1
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    280

    Thumbs up formula to copy data from upper cell to down cell untill any change

    Hi all,

    I get some date from software, as per attached file, i want to delete all rows from row to until row where the word "start" is written..

    and I also wnat to copy "A" untill "B" and same "B" untill "C"..

    is there any way to do it..

    Thanks in advance for any help..

    SAMPLE1.xlsx
    Last edited by tariqnaz2005; 07-14-2011 at 09:02 AM.

  2. #2
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: formula to copy data from upper cell to down cell untill any change

    Try this in E11
    Please Login or Register  to view this content.
    Drag/Fill Down.

    Hope this helps.
    If you need any more information, please feel free to ask.

    However,If this takes care of your needs, please select Thread Tools from menu above and set this topic to SOLVED. It helps everybody! ....

    Also
    اس کی مدد کرتا ہے اگر
    شکریہ کہنے کے لئے سٹار کلک کریں
    If you are satisfied by any members response to your problem please consider using the small Star icon bottom left of their post to show your appreciation.

  3. #3
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    280

    Re: formula to copy data from upper cell to down cell untill any change

    Thanks for quick reply, it works great, but it gives 1 problem, because some time "D13 to D28" can be not in serial, i mean it can be any number like 1234, 67858, 34575, ..it is not necessary that it would be in serial number like 1, 2,3..
    Pls give another look to make it correct..

    and also 1 another issue, the value in comun D , which i take from a software like 1,2,3,4 is showing as text..how can i change them in to numbers format..thanks

  4. #4
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: formula to copy data from upper cell to down cell untill any change

    Try this workbook.

    It uses a helper column to count each group.

    To change text to numbers use Text to Columns and then format the column Number Format = "general" and Alignment = "general"

    Just select the column then Text to Columns > Press "Finish"
    Attached Files Attached Files
    Last edited by Marcol; 07-14-2011 at 08:33 AM.

  5. #5
    Registered User
    Join Date
    07-13-2011
    Location
    Chennai, India
    MS-Off Ver
    Excel 2003
    Posts
    7

    Thumbs up Re: formula to copy data from upper cell to down cell untill any change

    --------------------------------------------------------------------------------

    Hi all,
    I have a problem in extracting latest can anyone help me
    Last edited by mrsrinivas1988; 07-14-2011 at 09:12 AM.

  6. #6
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: formula to copy data from upper cell to down cell untill any change

    @ mrsrinivas1988
    You must start a new thread, not add a totally unrelated question to someone elses' thread.

    Read this Forum Rules

    Delete your post and start your own thread before the moderators get you ...

  7. #7
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    280

    Re: formula to copy data from upper cell to down cell untill any change

    Thanks marcol, its work perfect, but last question, if i put "123-A" instead of only "A" in your attached sheet "tariqnaz2005_sample" cell D19, it gives me wrong answer, so i have to delete manually formula in cell E19. I dont want to delete manually farmula,

    so, any solution pls?

  8. #8
    Forum Guru (RIP) Marcol's Avatar
    Join Date
    12-23-2009
    Location
    Fife, Scotland
    MS-Off Ver
    Excel '97 & 2003/7
    Posts
    7,218

    Re: formula to copy data from upper cell to down cell untill any change

    Have a look at this amended workbook
    Attached Files Attached Files

  9. #9
    Forum Contributor
    Join Date
    07-21-2009
    Location
    Kuwait
    MS-Off Ver
    Excel 2016
    Posts
    280

    Re: formula to copy data from upper cell to down cell untill any change

    thanks Marcol. it works fine now.. God bless you

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1