Search results 89

Sorted from new to old.
Card image
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Card image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Card image
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

Card image
SaveAsHTML_Template

Creates HTML file using template found in a column. Have lines of HTML in a ...

Card image
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

Card image
CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

Card image
Most recent in Oracle DB

List the most recently added rows based on a date column.

Card image
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

Card image
all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

Card image
CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

Card image
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

Card image
tAutocomplete

Dropdown list for input box works as Autocomplete Multi-column, themeable ...

Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...