Search results 90

Sorted from new to old.

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Range2Block

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

2023Mar6

ANmaRemoveDuplicates

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

2022Sep25

ANmaSQL_UpdateDateStatement

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

2022Jul4

Export2CSV

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

2022May16

CreateUniqueList

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

2022Apr26

SaveAsHTML_Template

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

2022Feb5

GetColumnIndex

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

2021Nov26

ConcaUFO_RowsfromSheets

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

2020Nov11

CreateList_Matching

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

2020May13

Most recent in Oracle DB

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

2020Feb7

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

all_tab_columns

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

2019Dec22

CountArrayCol

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

2019Aug9

Rows 2 Cell

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

2019Jul30

tAutocomplete

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

2019Jun25

1 2 ...4 5 6