This Excel tutorial shows how to use custom VBA Excel Function to sort data in ascending order instead of using Filter.
You may also want to read
Sort data using custom Function by assigning number to Text
Sort data using Range Sort Method
Sort data using Table AutoFilter
Sort data using Worksheet AutoFilter
Use VBA Excel Function to sort data in ascending order
In this tutorial, I will show how to use VBA Excel Function to sort data instead of using Filter.
This was origin...
Read More
Unit 8 – Excel Custom Function (UDF)
VBA Access Excel Remove duplicates in text
This tutorial provides a custom Access Excel VBA Function to remove duplicates in text, parameters provide flexibility of case sensitivity and delimiter
You may also want to read:
Access Excel Scripting Dictionary store unique array item
VBA Access Excel remove duplicates in text
This tutorial is to help you to remove duplicates in text (in a Cell), but it is not about removing duplicated Cell value in a column. To remove duplicated Cell value in a column, highlight the column, navigate ...
Read More
Access Excel VBA extract number from text or extract alphabet
This tutorial shows several Access Excel VBA custom functions to extract number from text, extract alphabet from text, extract symbols from text
Excel Access VBA extract percentage from text
Excel Extract Time from Date Time or Extract Date
Access Excel extract file name from file path
Access Excel VBA extract number from text or extract alphabet from text
In this article, I will show a list of custom Functions to perform the following tasks.
- Check if a text contains any alphabet, ...
Read More
Access Excel Function HKID Check Digit (last digit)
This Excel tutorial explains the algorithm of HKID Check Digit (last digit) and provide a custom Access Excel VBA Function to verify the Check Digit. (香港身份証最後號碼)
You may also want to read:
Access Excel Generate random HKID Hong Kong ID card number
HKID Check Digit
Hong Kong ID card number has a last digit with bracket called "Check Digit". Check Digit is a number to verify if the previous number and alphabet are correct. By understanding the algorithm of calculating Check Digit, you ...
Read More
Excel VBA Round Function and custom Round Function
This tutorial explains difference between Excel VBA Round Function and Excel worksheet Round Function, and create a custom Excel Round Function.
Excel VBA Round Function and custom Round Function
Excel VBA Round Function is completely different from Excel worksheet Round Function.
For Excel spreadsheet Round Function, if decimal part is >=0.5, the integer rounds up, otherwise the integer rounds down.
For Excel VBA Round Function, as well as Access VBA, the Round Function uses "Round t...
Read More
Custom VBA Excel Access Networkdays Function
This tutorial explains how to create a custom Excel Access Networkdays Function to simulate Excel Networkdays Function, exclude holiday and weekend
Why do we need Access Networkdays Function?
As of Access 2013 version, there is no Access Networkdays Function available, the function is only available in Excel all versions.
In Excel , Networkdays Function is used to calculate the number of "net working days" between two days, excluding Saturday and Sunday, and include both start date and end ...
Read More