+ Reply to Thread
Results 1 to 1 of 1

Convert Matrix to List (excluding blank cells from list)

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    Gold Coast, Australia
    MS-Off Ver
    Excel 2010 (Mac)
    Posts
    1

    Convert Matrix to List (excluding blank cells from list)

    Hi,

    I have a matrix that I need to convert into a list so that I can graph it, but I am unable to extract the data and then sort it while excluding blank cells. I tried to make a list that equal the individual cells, but when you sort it became horribly incorrect. I have attached a worksheet that has an example of a matrix I'm working with.

    My current method of constructing a list returns something like this:

    45
    5
    -blank-
    -blank-
    64
    14
    -blank-
    22

    where as I would like it to be

    5
    14
    22
    45
    64

    Where the blanks are left out from the matrix and the data is in numerical order

    Cheers,
    Attached Files Attached Files
    Last edited by cameron.rumball; 04-02-2013 at 02:18 AM.

+ 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