Search results 113

Sorted from new to old.

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

May4

MatchIf7Up

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

May3

MatchIf7

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

May2

MatchIf4Up

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

Apr12

VBInstr_Rev_Any

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

Apr11

String_Fx

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

Apr10

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

ANmaSafeDeleteFile

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

Mar10

CutString_ANmaRules

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

Feb26

HTMLTableRow_LastRowWithData

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

Feb19

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

Jan12

ANmaSum_5IFs

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

Jan8

YoutubeLinks2YoutubeEmbeds

Convert all links in text block into youtube embeds to show inside a website. ...

2024Dec22

ANmaRemoveDuplicates2

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

2024Dec4

1 2 ...7 8