Browse codes

ANmarAmdeen 876

Removes duplication in table in 1 or more columns. Will work in sheet, ...

Sun Sep25 6AM

Filter table inside Excel the fast way (using advanced filter) into another ...

Thu Sep15 8AM

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

Thu Sep1 9AM

Read list of items from Settings sheet, then Sort, then save, before reading ...

Wed Aug31 3PM

Creates batch file with certain content, and another function to actually ...

Thu Aug25 6AM

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

Wed Aug24 4AM

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

Mon Aug22 11AM

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

Thu Aug18 9AM

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

Wed Aug17 9AM

Removes last row in a table starting certain cell. Creating and using this ...

Tue Aug16 9AM

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

Fri Aug12 9AM

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

Sun Jul24 6AM