BoldCodes

Search results 69

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

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

2023Oct7

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

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

2023May11

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

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

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