Search results 63

Sorted from new to old.

Random Number in SQL

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

Jan30

UnUnixDateTime

Convert a number represents a date in Unix format back into date, opposite of ...

Jan6

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

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

FoundinList

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

2022Aug12

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

1 2 3 4