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,
Bookmarks