Search results 67

Sorted from new to old.
Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Card image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

Card image
ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

Card image
ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Card image
Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Card image
Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Card image
Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Card image
ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

Card image
Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

Card image
SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Card image
HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Card image
Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

Card image
WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Card image
Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...