Browse codes

Search results 20

Imports a range into 2-dimension array. Returns the array, providing range, ...

May11

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

May2

Formula to show progress to end user from inside two loops. More like an ...

Mar7

Adds an amount (or subtract) from a range of cells in one click Similar to

Feb18

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

2022Sep1

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

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

2021Sep23

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Copies objects from cell into cell Decide Sheet, and workbooks to copy from or ...

2020Nov11