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