You are here List of extension functions in Add-In A-Tools in Microsoft Excel

Query, Share and Manage Excel workbooks on LAN, Internet

List of extension functions in Add-In A-Tools in Microsoft Excel

BS_USD(Number):Transform text to numbers in excel

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 unique color inrange.

BS_GetColorValue(CelltoGetColorValue): Get color value

BS_Unique(RangeOrArray, SortType, Option):Get list of unique value.

BS_GetFieldNames(TableName,Option): Get list of filed names in table

BS_GetTableNames(Option): Get list of table names in database

BS_GetProcNames(Option): Get list of procedure names in database