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

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top