BoldCodes

Search results 96

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 databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

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

2022Jul19

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4

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

2022May16

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

2022Apr26

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

2022Mar11

Creates HTML file using template found in a column. Have lines of HTML in a ...

2022Feb5

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

2022Jan1