Similar codes

Card image cap
SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Card image cap
CountDuplicates

Counts how many duplicates found in a range of Excel cells. Basically how many ...

2020Oct31

Card image cap
CopyFormat

Applies format into a cell (or range) from another cell. Can apply from any ...

2018Aug10

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Oct7

Card image cap
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

Card image cap
SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

Card image cap
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Jan25

Card image cap
SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

Recently by developer

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Tue 8AM

Card image cap
SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

Card image cap
ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

Card image cap
CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

Random Codes

Card image cap
Mini Ajax-php upload form

Simple elegant form to upload files with php/ajax. From

Feb15

Card image cap
FeeKey + UnFeeKey

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

2020Nov11

Card image cap
Match2

Matching by two values at the same time in two columns Just like Match the ...

2018Jun16

Card image cap
Hex2Bin

Converts Hex to Binary

2018May28