Similar codes

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Card image cap
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

Card image cap
HMatchIf

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

2018Jun16

Card image cap
Tabs3-BS3

Tabs in Bootstrap 3, custom design with hover effect, 3 top and 3 bottom

2019Feb13

Card image cap
CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

Card image cap
Row_PixelLocation

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

2021Feb2

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Column2AnString_Unique

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

2020May6

Card image cap
DB_AllRows

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

2018Apr23

Recently by developer

Card image cap
MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

Card image cap
Files_FoundHours

Listing the file from a folder that was created during last few hours. Can ...

Apr30

Card image cap
MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

Random Codes

Card image cap
CalcArea

Calculates the area of objects. Pass formula argument as string and values as ...

2018Jul24

Card image cap
SharePointURL2Path + Path2SharePointURL

Converts SharePoint URL to regular folder path and the other way, giving the ...

2018Jun30

Card image cap
RandBetween

Generating random number between two

2018Apr25