Search results 181

Sorted from new to old.
Card image
MatchIf7Up

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

Card image
MatchIf7

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

Card image
ANmaUploadFTP_FilesListto1Folder

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

Card image
ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Card image
FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Card image
ANmaRow_Duplicate1

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

Card image
MatchIf4Up

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

Card image
String_Fx

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

Card image
DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Card image
ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Card image
ANmaSum_5IFs

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

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
Match6_Until

Searches for six values in six columns and return the row number if all found, ...

Card image
Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

Card image
ANmaRemoveBlanks_1Col

Remove blank cells from 1 column