Search results 180

Card image cap
TextPercentageMatch

Matching any part of a string in another , then returns 0 if not match, Or ...

Card image cap
WeekNum

Generates the calendar week number for a certain date, counting the first week ...

Card image cap
TimeRound

Rounds the number of minutes to the nearest quarter of half like 4:32 to 4:30 ...

Card image cap
LogSheet_Add + LogSheet_Clear

2 Functions LogSheet_Add and LogSheet_Clear to add new entry to log or clear ...

Card image cap
confirmDelete

Asks user before running a link (mostly before deleting) Small important part ...

Card image cap
MatchIf_ThenDelete

Searches for an item in a column, then if found, delete that cell (not clear, ...

Card image cap
Match4

Matching 4 values at the same time in 4 columns Just like Match the function, ...

Card image cap
Match3

Matching three values at the same time in three columns Just like Match the ...

Card image cap
Match2

Matching by two values at the same time in two columns Just like Match the ...

Card image cap
HMatchIf

Horizontal match for a value in a row Horizontal MatchIf, returns column ...

Card image cap
MatchIf (aka VMatchIf)

The best Match I created, return 0 if not found, kind of CountIF+Match ...

Card image cap
Reversefile

Reversing a file This tip demonstrates how to reverse a whole file. This ...