Search results 35

Sorted from new to old.

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

2024Nov13

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

UniqueRandomID in SQL

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

2024Feb18

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

2022Nov13

ANmaRemoveDuplicates

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

2022Sep25

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

ASPUsers

Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...

2022May4

CreateUniqueList

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

2022Apr26

1 2 3