Search results 135

Sorted from new to old.

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

2024Apr8

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

ProgressPie SVG

jQuery library to create ProgressPie SVGs. Simple, perfect, works

2024Feb10

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

2024Feb8

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

2023Dec17

ReverseArray

Reverses order of array. In other words, the upperbound value of an input ...

2023Nov27

ANmaFilter3

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

2023Oct13

SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

2023Sep3

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

Refresh Table from View

Convert SQL View into table for speed reading. Using views a lot, I needed a ...

2023Jul19

1 2 ...8 9