a few clarification points:
Do you want the output in a single column/row, same size read left-to-right,
or same size read top-to-bottom?

Also, your example says "text" but as you also have zeroes, are you dealling
with actual text, or is it numbers? (numbers would be much easier!)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"MarkBrazier" wrote:


Hi,
I have a 2D array (sample below - actual array is 16 columns x 200 rows
and any cell with no data will contain a zero), and I need to sort all
entries into an ordered list, ignoring the zeros.

Text3 Text4 Text1 0
Text6 Text8 Text2 0
0 0 Text5 0
0 0 Text7 0
0 0 Text9 0
0 0 0 0

I have found a few different formula that can take & sort a 1D array,
but yet to find one that helps me with this 2D array problem.

Thanks,

Mark


--
MarkBrazier
------------------------------------------------------------------------
MarkBrazier's Profile: http://www.thecodecage.com/forumz/member.php?userid=610
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=121942