Search results 487

Sorted from new to old.

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

QuickEncrypt plus others ...

Text encryption/decryption snippet that utilizes the powerful xICE encryption ...

Aug15

MouseDown and MouseUp in FM20 controls

Full story of MouseDown and MouseUp in FM20 controls

Aug15

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

Jul27

Quarter1stLastDate_FromQuarterText

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

Jul26

QuarterNumber_FromDate

Returns the number of quarter from a date

Jul26

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Jul13

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Jul13

ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Jul11

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

Jun10

Q_NoOfdays

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

Jun9

ANmAdd_ThenSort_2Columns

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

Jun1

1 2 ...30 31