Search results 60

Sorted from new to old.

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

RangeValues

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

2024Jan25

CutLeftNumber

Cuts the left part of string as long as it is number Keeps getting characters ...

2023Dec31

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

Any2Dec

Converts a number of any base to decimal. Hexa to decimal, octa to decimal, ...

2023Sep20

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

2023May3

SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

2022Oct17

RowList_Matching

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

2021Dec27

NMRRank_v2021

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

2021Sep23

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

NameNum

Finding the number of a name, used in a numerology program. Finds the number ...

2020Mar21

1 2 3 4