close
looking for a way to query an array 3 cells by 3 cells (they have numeric
data only) and return a value in a seperate cell that has all the numbers in
the array (comma delimited)
thanks
If C1 thru E3 contain:
123
456
789
then:
=C1 amp; quot;,quot; amp; D1 amp;quot;,quot;amp; E1 amp;quot;,quot;amp; C2 amp;quot;,quot;amp; D2 amp;quot;,quot;amp; E2 amp;quot;,quot;amp; C3 amp;quot;,quot;amp; D3 amp;quot;,quot;amp; E3
will return:
1,2,3,4,5,6,7,8,9
--
Gary's Studentquot;bbquot; wrote:
gt; looking for a way to query an array 3 cells by 3 cells (they have numeric
gt; data only) and return a value in a seperate cell that has all the numbers in
gt; the array (comma delimited)
gt; thanks
全站熱搜
留言列表
