Search results 60

  2. Search results
  3. There might be a bug when row starts below list of items in that column
Sorted from new to old.
Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27
Card image
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13
Card image
Frm6 - ANmaMultiSelect

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

2021Jun23
Card image
ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24
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
ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6
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
Card image
all_tab_columns

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

2019Dec22
Card image
CountArrayCol

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

2019Aug9
Card image
Rows 2 Cell

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

2019Jul30
Card image
tAutocomplete

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

2019Jun25
Card image
Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16
Card image
MatchLastIf

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

2019Jun12
1234