This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Attribute VB_Name = "mod_JOINTEXT" | |
| Option Explicit | |
| Public Function JOINTEXT(Delimiter As String, Ignore_Empty As Boolean, ParamArray Text1() As Variant) As String | |
| 'PURPOSE: Replicates The Excel 2016 Function CONCAT | |
| 'UPGRADED by: HocExcel.Online | |
| 'SOURCE: www.TheSpreadsheetGuru.com | |
| Dim Cell As Variant, RangeArea As Variant | |
| Dim x As Long |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Attribute VB_Name = "mod_JoinIF" | |
| Option Explicit | |
| '============ Hàm UDF: JOINIF, Gop chuoi theo dieu kien | |
| '++ Functions: UniqueArray, JOINIF | |
| '-- HOCEXCEL.ONLINE | |
| '-- =JOINIF(VungDieuKien, DieuKien, VungKetqua, Kytuphancach, Locbotrung, Hienthidieukien) | |
| '-- Mac dinh: Kytuphancach: "," , Locbotrung: false, Hienthidieukien: false | |
| '-- | |
| Function JOINIF(CriteriaRange As Range, Condition As Variant, ConcatenateRange As Range, _ | |
| Optional Separator As String = ",", Optional RemoveDuplicate As Boolean = False, _ |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| <?php | |
| /** | |
| * Copyright 2011 Facebook, Inc. | |
| * | |
| * Licensed under the Apache License, Version 2.0 (the "License"); you may | |
| * not use this file except in compliance with the License. You may obtain | |
| * a copy of the License at | |
| * | |
| * http://www.apache.org/licenses/LICENSE-2.0 | |
| * |