Skip to content

Instantly share code, notes, and snippets.

View tdn2kit's full-sized avatar

D.Nguyen tdn2kit

View GitHub Profile
@tdn2kit
tdn2kit / JOINTEXT.bas
Last active November 29, 2018 10:32
mod_JOINTEXT
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
@tdn2kit
tdn2kit / JOINIF.bas
Last active February 15, 2022 14:30
Excel JOINIF
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, _
@tdn2kit
tdn2kit / Facebook Notes Exporter
Created September 23, 2013 09:45
Export Facebook Notes to Wordpress Import XML
<?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
*