All Microsoft Excel Versions

Evaluate Work Hours Excluding Breaks

In case you are evaluating work hours without including break timings then this article is for you. In this article, we will calculate work hours base...

Conditional Formatting to Detect Re-Occurrences

While working on Excel data, most of the times, we want to know if the duplicates are automatically highlighted so that the viewer can easily view the...

Vlookup to Find Last Matching Value

Lookup Function to Get Last Matching Value in Microsoft Excel If you are wondering what formula should be used in order to get the last matching va...

Index & Match find value with new Date

Index & Match to Find Value by Latest Date in Microsoft Excel If you are looking for a formula to find the lookup value & latest value by d...

Extract Specific Color Index using VBA

In case you want to copy a particular formatted cell or colored cells from one column to the next column then this article is for you. In this article...

Get Sheet Names

How To Get Sheet Names Using VBA in Microsoft Excel   In case you want to find out a way which can get you all the names of the sheet that ...

VBA To Open Latest File in Folder

How to Open Newest File in a Folder in Microsoft Excel   In case you want a VBA code which will allow you to open the recently saved file i...

UDF to Extract only Number

UDF to Extract only Number from a Cell Using VBA in Microsoft Excel   In this article, we will learn how to use VBA code to extract number...

Insert Date Time Stamp with VBA

In case you want a VBA code to automatically record date & time stamp in a specific cell & insert date & time stamp based on the changes i...

Max Value Multiple Columns

Formula to Find MAX Value Based on Multiple Criteria in Microsoft Excel If you want to find max value with two or more columns with regards to outp...

Page 3 of 10512345...102030...Last »
Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube