Search results 114

Sorted from new to old.

DB Connection Drivers Test

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

Mar12

ANmaRemoveDuplicates2

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

2024Dec4

ANmaRemoveDuplicates4

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

2024Dec4

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Choose20

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

2024Sep5

Choose10

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

2024Sep3

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

2024Jul13

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

1 2 ...7 8