Search results 209

Sorted from new to old.

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaUploadFTP_FilesListto1Folder

Creates script to upload list of files found in column. Will upload all files ...

2025May1

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

2025Apr17

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

2025Mar13

DB Connection Drivers Test

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

2025Mar12

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

2025Mar10

CutString_ANmaRules

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

2025Feb26

HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

2025Feb19

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

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

1 2 ...13 14