Search results 198

Sorted from new to old.

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

2023May5

ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

2023Apr23

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

2023Apr23

WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

2023Apr22

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

ArrSort_4Arr

Sort 4 1-dimension arrays Actually sort 1st array (arrShort) based on values ...

2023Apr14

Arabic in MySQL

Here is how to read Arabic text from MySQL db from Classic ASP I tried a lot ...

2023Apr12

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

ANmaVLookup

Finds first occurrence of item in column, then returns value from same row as ...

2022Dec23

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

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

2022Aug22

ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24

SQL Related posts

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

2022Jul6

ANmaSQL_UpdateDateStatement

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

2022Jul4

1 2 ...5 ...12 13