Search results 57

Sorted from new to old.

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

Toggle5Values

Toggles among up to 5 values. Pass the current values, then up to 5 values (in ...

Feb2

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Feb1

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

Quarter1stLastDate_FromQuarterText

Returns the date of 1st day or last day in a Quarter Mar 31st, Jun 30th, Sep ...

2024Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

Between2int and Between2intinc

Checks if number between two numbers, with or without considering those numbers. ...

2024Mar23

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

ConcatenateStrings_AmongString

Collect strings matching search from a longer string. I used it to concatenate ...

2024Jan17

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

SQL Date from DateTime

Extract Date from Datetime field in SQL An old method I found in my archive.

2023Nov29

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

1 2 3 4