Search results 56

Sorted from new to old.

Variable_PerLocation_FromFullLine

Extract set from ANstring, like 2nd set of variable list using specific ...

2025Oct16

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

2024Aug20

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

Minify + Unminify tools online

Minify and unminify tools online, mainly js and css, free Unminify js, css, ...

2024Jan27

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

2023Nov26

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

2023Apr4

COUNTIFS as Rank

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

2022Jan1

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

EnvironList

List of all variables of Environ It will populate them in sheet range starting ...

2021Jan12

GenerateThumbnail.php

Generates thumbnail of an image and saving it in certain folder. Edit php to ...

2020Dec24

Wrong file permissions

Fix to unable to delete file from FTP server after uploading using PHP function ...

2020Dec21

1 2 3 4