Similar codes

Card image cap
MatchIf6Up

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

May31

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
CountColumnCells + CountColumnCells_Criteria

Counts how many cells in a column in any sheet, any workbook using COUNTIF ...

2018May23

Card image cap
Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

Card image cap
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Oct7

Card image cap
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

Card image cap
DB_AllRows

Returns all rows found from an SQL Query as string Separated by row and column ...

2018Apr23

Card image cap
Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

Recently by developer

Card image cap
ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

Sat 3PM

Card image cap
ANmaReplace_Occurrence

Replaces certain occurrence of a string with another inside a string. Like ...

Sat 8AM

Card image cap
ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

Sat 7AM

Card image cap
ANmaSearch_AposFriends

Searches for string inside string with apostrophe possibility (or as I call ...

Thu 7AM

Random Codes

Card image cap
Progress in two nested loops

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

2023Mar7

Card image cap
Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Card image cap
Boxed Shadow2

Pure CSS shadow effect A Pen created at CodePen.io. You can find this one at ...

2019Jan17

Card image cap
Files_MostRecentN

Gets most recent N files from a given folder. Uses Arrays, and the function ...

2018Oct1