Extension functions in Add-In A-Tools:
BS_USD(Number): Number to words functions
BS_Sumifcolor(RangeColor, Condition_Color, RangeCal): Same as Sumif Function in Excel, but Range is replace by RangeColor and Criteria is replace  by Condition_color. 
BS_CountIfColor(RangeColor,Condition_Color,[RangCal]): Same as Countif Function in Excel but Range and condition are colors.
BS_SubtotalifColor(RangeColor,Condition_Color,RangCal,FuncName): Same as Subtotal but Range and condition are colors
BS_CountColorUnique(RangeColor): Count number of colors in range
BS_GetColorValue(CelltoGetColorValue): 
BS_Unique(RangeOrArray, SortType, Option): Get unique list
BS_GetFieldNames(TableName,Option)
BS_GetTableNames(Option)
BS_GetProcNames(Option)

0 Comment:

Đăng nhận xét

Excel Thỉnh Vũ. Được tạo bởi Blogger.