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...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top