Search results 134

Sorted from new to old.

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

ContainerHTMLTag_Index

Returns location of the tag that enclosing the location provided inside HTML ...

2023Oct22

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

ReadLastChars

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

2023Apr20

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

2023Mar7

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

2023Jan11

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

1 2 ...4 ...8 9