Search results 204

Sorted from new to old.

Export2CSV

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

2022May16

CreateUniqueList

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

2022Apr26

DateDiff_En

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

2022Mar3

ANmaFill

Fill down series in Excel range starting from certain number with certain ...

2022Jan5

RowList_Matching

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

2021Dec27

Subtotal_Indirects

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

2021Nov26

Special chars

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

2021Oct13

NMRRank_v2021

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

2021Sep23

CleanArray

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

2021Sep22

Morse code functions

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

2021Jun13

Navigate_IE

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

2021May31

RandomUniqueID_Sheet

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

2021May29

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

Row_PixelLocation

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

2021Feb2

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

1 2 ...7 ...12 13