Search results 60

  2. Search results
  3. date range
Sorted from new to old.
Card image cap
Range2Block

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

2023Mar6
Card image cap
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

2023Feb18
Card image cap
UnixDateTimeNumber

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

2023Jan6
Card image cap
ANStr2Range

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

2022Nov11
Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19
Card image cap
DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3
Card image cap
Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16
Card image cap
IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30
Card image cap
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23
Card image cap
merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

2021Sep21
Card image cap
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29
Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29
Card image cap
Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22
Card image cap
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31
Card image cap
Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14
Card image cap
Most recent in Oracle DB

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

2020Feb7
1234