Search results 49

Sorted from new to old.

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

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

1 2 3 4