BoldCodes

Search results 145

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

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

2022Sep15

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

2022Sep1

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

2022Aug31

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

2022Aug24

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

2022Aug22

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

2022Aug18

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

2022Aug16

Selects a shape inside sheet to change it, or if not found, it will create it ...

2022Jul21

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19