Search results 49

Sorted from new to old.
Card image
ANmaDropdown Search

Shows drop down menu of matching items when user searches in textbox with ...

Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Card image
MatchIf8

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

Card image
ANmaUploadFTP_FilesFrom2Columns

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

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
MatchIf4Up

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

Card image
String_S

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

Card image
HTMLTableRow_LastRowWithData

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

Card image
ANmaRemoveDuplicates2

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

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
ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Card image
Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Card image
ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.