Search results 80

  2. Search results
  3. columns
Sorted from new to old.
Card image
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11
Card image
Convert_Dash_to_Zero

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

2023Mar14
Card image
Range2Block

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

2023Mar6
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
Export2CSV

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

2022May16
Card image
CreateUniqueList

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

2022Apr26
Card image
SaveAsHTML_Template

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

2022Feb5
Card image
GetColumnIndex

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

2021Nov26
Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23
Card image
ConcaUFO_RowsfromSheets

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

2020Nov11
Card image
CreateList_Matching

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

2020May13
Card image
Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6
Card image
Most recent in Oracle DB

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

2020Feb7
Card image
FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3
Card image
Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3
12345