Search results 84

Sorted from new to old.

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ImgDimensions

Reads image dimensions, width, height, depth and image type. Details returned ...

2024Jan16

CutString9

Cuts from CutFrom starting from any of items found from ...

2024Jan7

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

2024Jan1

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

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

UnixDateTimeNumber

Calculates Unix date/time number of a given date/time. Needed it to pass ...

2023Jan6

ANStr2Range

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

2022Nov11

FoundinList

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

2022Aug12

Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

CopyFiles

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

2022Feb3

1 2 ...5 6