Browse codes

Search results 68

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

Tue Jul19 3AM

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

Mon Jul4 7AM

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

Mon May16 10AM

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

Tue Apr26 12PM

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

Fri Mar11 8AM

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

Sat Feb5 7AM

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

Sat Jan1 6PM

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

2021Nov26

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

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

2021Sep2