Search results 48

Sorted from new to old.

Range2Block

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

2023Mar6

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmaRemoveDuplicates

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

2022Sep25

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

RowList_Matching

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

2021Dec27

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

ANSQLWherein

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

2020Jan6

GetWordCount

Counts how many words found inside a string. Using space, tab or enter as ...

2019Mar31

Split string into table

Returns tag words (as table) in Microsoft SQL Separator set to comma, but you ...

2018Dec18

Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1

FixPath_Word

Fixes the path for a given folder, PC or Mac by adding separator only if ...

2018Aug9

ConvertMultiLine2 + 6

Convert text blocks (by converting line separators from any separator to any). ...

2018Jul11

1 2 3