Search results 192

Sorted from new to old.
Card image
SwapNumbers

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

Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image
AddDatabar_ConditionalFormatting

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

Card image
DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

Card image
FoundinList

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

Card image
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Card image
CreateUniqueList

Create list of unique items from a column into another column This is similar ...

Card image
DateDiff_En

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

Card image
RowList_Matching

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

Card image
Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

Card image
Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

Card image
NMRRank_v2021

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

Card image
CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

Card image
Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

Card image
Navigate_IE

Reads HTML source page of a webpage, maynot work for heavy js pages, but works ...

Card image
RandomUniqueID_Sheet

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