array.join

  1. T

    Using ARRAY.JOIN in an INDEX and MATCH formula

    I'm trying to write an "index & Match" formula that uses the "Morefunc" function, "ARRAY.JOIN" to join nonadjacent ranges, such as: =INDEX((ARRAY.JOIN(C3:C30,G3:G30)),MATCH(N5,ARRAY.JOIN(B3:B30,F3:F30),0)) This formula results in the #VALUE error. Any suggestions? is it not possible to use...
  2. A

    MoreFunc Array.Join Alternative

    Hey everyone, Do any of you know an alternative to the Array.Join function (either formula or UDF) in Excel as I have traced the source of my crashing workbooks to this function which in all instances concatenate two named ranges of text data, and then produce a list of unique values using the...
  3. J

    Need Help in VBA MACRO for Summing up values using Array

    Hi Gurus, Could anybody help me in writing a simple macro to sumup values as mentioned in the example. A B C 1 4 5 176 2 693 6 3 1067 56 1492 4 1068 109 5 1079 694 6 1089 798 Here results are marked in RED...
  4. A

    Morefunc ARRAY.JOIN function

    Hey there, Has anyone experienced the ARRAY.JOIN function producing different results (when combined WITHIN the UNIQUEVALUES function) when used in the same workbook, but opened on different computers all using the same OS (Windows XP) and the same version of Excel (2007 with all updates...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top