+ Reply to Thread
Results 1 to 7 of 7

How to create an Array an use the content

  1. #1
    Registered User
    Join Date
    08-26-2010
    Location
    Halden, Norway
    MS-Off Ver
    Excel 2007
    Posts
    27

    How to create an Array an use the content

    Hi all,

    I have a dynamic row of data.

    I use this line to count how many Columns that have data in one Row:

    Please Login or Register  to view this content.
    I would like to get data in B4 and C4 to do calculation, then C4 and D4 to do calculation, then D4 and E4.... til there are no columns that contain data i Row 4.

    I have tried to program this, but with no luck.

    If any of You find time to help I will be grateful.

    Thanks in advance.
    Last edited by jmadsen; 09-01-2010 at 07:45 AM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to create an Array an use the content

    It might help if you outline

    a) the calculation to be performed

    b) what you're doing with the results of the calculations

    the answers to both will determine the most appropriate approach

  3. #3
    Registered User
    Join Date
    08-26-2010
    Location
    Halden, Norway
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: How to create an Array an use the content

    Hi and thanks for the reply.

    I want to calculate the difference in % between B4 and C4, C4 and D4, and so on...

    The result will be copied to another sheet in the same workbook.

    Ex.:
    B4 C4 D4 ...
    10 5 10

    Result of B4 and C4 = 100% copied into xx in sheet2
    Result of C4 and D4 = -50% copied into xx in sheet2

    Regards,

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to create an Array an use the content

    Care to elaborate regards the nature of "Sheet2!xx" - ie the specifics of the results range and how it increments result by result ?

  5. #5
    Registered User
    Join Date
    08-26-2010
    Location
    Halden, Norway
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: How to create an Array an use the content

    Sorry about the xx confusion.

    Result of B4 and C4 = 100% copied into xx in sheet2
    Result of C4 and D4 = -50% copied into xx in sheet2

    The result of B4 and C4 should be copied into e.x. A1 in Sheet2 and the
    result of C4 and D4 should be copied into B1 in sheet2...

    The results should be copied one cell to the right of the last cell til the loop is finished.

  6. #6
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: How to create an Array an use the content

    Perhaps then:

    Please Login or Register  to view this content.
    Last edited by DonkeyOte; 08-31-2010 at 07:53 AM. Reason: added Number Format line

  7. #7
    Registered User
    Join Date
    08-26-2010
    Location
    Halden, Norway
    MS-Off Ver
    Excel 2007
    Posts
    27

    Re: How to create an Array an use the content

    Excellent,

    Worked fine.

    Thanks alot for all help.

    Regards,

+ 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