Search results 141

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

Mon 5PM

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

Nov3

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

Oct26

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Oct24

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

Choose20

Chooses from 20 options based on the passed ID, can have any of these passed. ...

Sep5

Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Sep3

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

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

Jun22

JSON_To_Table

An attempt to read json into table. This one is a work in progress, tested and ...

Jun6

MatchIf6Up

Searches for 6 values in 6 columns and return the row number found in. ...

May31

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

1 2 ...8 9