Similar codes

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
CellRead (SimpleLookup)

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

2018Jun25

Card image cap
CellSave and CellRead

Reads a cell or Saves value into certain cell, in certain sheet and workbook. ...

2020Oct31

Card image cap
SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Card image cap
ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

Card image cap
FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Card image cap
ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

Dec23

Card image cap
MatchIf (aka VMatchIf)

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

2018Jun16

Card image cap
Match4

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

2018Jun16

Recently by developer

Card image cap
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Wed 7AM

Card image cap
Files_FoundHours

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

Tue 7AM

Card image cap
MatchIf2Up

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

Mon 9AM

Card image cap
ANString_Location

Finds the location of a sting inside list of strings with certain separator, or ...

Apr23

Random Codes

Card image cap
Win95 CSS

Win95 theme CSS with Bootstrap 4 From

May14

Card image cap
Language per app

Restore Windows 10 setting to remember language selected per application

2019Jan9

Card image cap
FormatMyDate

Formats a date, equivalent to VB6 function 'Format' Also with it, you will ...

2019Jan4

Card image cap
SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5