+ Reply to Thread
Results 1 to 9 of 9

Organizing array into column excluding non zero values

  1. #1
    Registered User
    Join Date
    02-22-2012
    Location
    Thailand
    MS-Off Ver
    Excel 2010
    Posts
    62

    Organizing array into column excluding non zero values

    Hi all!

    I would like to organize an array of data excluding the cells describing a space (got it wrong in the title). The data include a label and the actual number, these have to be organized in accordance to each other in a column.

    Sorry for the vague explanation, I have included an example.

    Thanks!

    Example problem.xlsx
    Last edited by Kybynn; 02-28-2012 at 12:08 AM.

  2. #2
    Registered User
    Join Date
    11-23-2011
    Location
    VietNam
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Organizing array into column excluding non zero values

    It is very difficult
    Try with formula
    Do you like VBA code?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    02-22-2012
    Location
    Thailand
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Organizing array into column excluding non zero values

    Thanks!

    I cannot use VBA, I have to do this in Excel.

    How do you create the Rcal and range labels?

    Cheers!

  4. #4
    Registered User
    Join Date
    11-23-2011
    Location
    VietNam
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Organizing array into column excluding non zero values

    Quote Originally Posted by Kybynn View Post
    Thanks!

    I cannot use VBA, I have to do this in Excel.

    How do you create the Rcal and range labels?

    Cheers!
    I said that it is very difficult, I cann't explain to you understand because English is not my mother's language, It is non language. I think you should have a basic knowledge about Excel, you can learn a formula in each by reading the help in excel, You can split it and then Press F9 to know How it is working!!!

  5. #5
    Registered User
    Join Date
    02-22-2012
    Location
    Thailand
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Organizing array into column excluding non zero values

    Ok,

    Thank you anyway!

    Cheers!

  6. #6
    Registered User
    Join Date
    02-22-2012
    Location
    Thailand
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Organizing array into column excluding non zero values

    I have it up and running now and it works great.

    Unfortunately I have a huge amount of data to be processed and a large amount of iterations to be carried out. Therefore I was wondering if there is a faster method to organize these data.

    Greetings,

  7. #7
    Registered User
    Join Date
    11-23-2011
    Location
    VietNam
    MS-Off Ver
    Excel 2003
    Posts
    24

    Re: Organizing array into column excluding non zero values

    Quote Originally Posted by Kybynn View Post
    I have it up and running now and it works great.

    Unfortunately I have a huge amount of data to be processed and a large amount of iterations to be carried out. Therefore I was wondering if there is a faster method to organize these data.

    Greetings,
    No Method, VBA? if you like VBA, i will write code for you

  8. #8
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Organizing array into column excluding non zero values

    An alternative with (slightly) less complicated formulas.
    Attached Files Attached Files

  9. #9
    Registered User
    Join Date
    02-22-2012
    Location
    Thailand
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Organizing array into column excluding non zero values

    Thanks a lot! It makes a big difference!

    Dank u wel! or Merci beaucoup!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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