Search results 60

Sorted from new to old.

CreateUniqueList

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

2022Apr26

RowList_Matching

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

2021Dec27

Special chars

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

2021Oct13

Frm6 - ANmaMultiSelect

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

2021Jun23

ANStrSort2

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

2020Sep24

CreateList_Matching

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

2020May13

Column2AnString_Unique

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

2020May6

Most recent in Oracle DB

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

2020Feb7

ANSQLWherein

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

2020Jan6

FilterSheet_1By1 + FilterSheet_Clear

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

2020Jan3

Add2Column

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

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

Excel 2010 hyperlink issue fix

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

2019Jun16

1 2 3 4