Search results 35

Sorted from new to old.

Choose2

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

Aug20

ANmaRead_1stFile

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

Aug11

ANmAdd_ThenSort_2Columns

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

Jun1

gsplit usage

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

Feb7

Random Number in SQL

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

Jan30

Minify + Unminify tools online

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

Jan27

UserChanged_Log4

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

2023Nov28

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

COUNTIFS as Rank

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

2022Jan1

GenerateThumbnail.php

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

2020Dec24

File2Body

Reads file and showing it as Bootstrap row, with ability to replace variables ...

2020Dec15

Resize_Me2 + Resize_Me3

Resizes Excel window to certain small size and location (hard-coded) and hide ...

2020Dec11

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

2020Oct31

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

ShortenDir

Shorten a long Dir by adding ... in the middle to make it fit in small boxes ...

2020Feb19

ShrinkText

Shrinks a text into smaller text controlling where is the majority will be ...

2019Oct20

1 2 3