Excel Mod

Create a Five Star Rating System

This post will guide you how to create a five star rating system in your current worksheet in excel. How do I change the five points system to five star rating in excel. How to use the conditional formatting function to create a five star rating system in excel. Create a Five Star Rating System… read more »

Highlight Multiples of Specific Value

This post will guide you how to search and highlight multiple values of a apecific value in excel. How to check if a number is a multiple of a specific number and then highlight those searched values in excel. Highlight Multiples of Specific Value If you want to highlight numbers that are multiples of a… read more »

Delete Every Other Row

This post will guide you how to delete every other row by filter command in Excel. How do I delete every other row in a selected range on a worksheet by Excel VBA Macro. Delete Every Other Row with Filter command To delete every other row in Excel, you need to filter alternate rows, and… read more »

Transpose Multiple Columns into One Column

This post will guide you how to transpose multiple columns into a single columns with multiple rows in Excel. How do I put data from multiple columns into one column with Excel formula; How to transpose columns into single column with VBA macro in excel. Assuming that you have a data list in range B1:D4… read more »

Excel MOD Function

This post will guide you how to use Excel MOD function with syntax and examples in Microsoft excel. Description The Excel MOD function returns the remainder of two numbers after division. So you can use the MOD function to get the remainder after a number is divided by a divisor in Excel. And the returned… read more »

How to Calculate Days, Weeks, Months and Years between Two Dates

This post will teach you how to calculate days, weeks, months and years between two dates in excel. How do I count the number of days, weeks, months and years between 2 dates in excel. Calculate days between two dates If you want to calculate the difference in days between two dates, you can use… read more »

Sidebar