FREE Calendar & Planner Excel Template for 2026
Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for 2025.
How to find duplicate values in two columns in Excel using formula
Let’s say you have two lists of values in Excel and want to find out all the common values (ie duplicates) and extract them. In this article, let me explain the formulas for this. Formula for counting number of duplicate values in two columns: Here is the formula to count number of common values between […]
How to lookup in any column – Excel Formula Trick
Do you want to lookup in any column and return the result? Something like this: In this article, learn how to write necessary Excel formulas to get the result. Data Setup for looking up in any column You need to set up your data in below structure. One column with the data you want to […]
FREE Calendar & Planner Excel Template for 2025
Here is a fabulous New Year gift to you. A free 2025 Calendar Excel Template with built-in Activity planner. This is a fully dynamic and 100% customizable Excel calendar for 2025.
Loan Amortization Schedule in Excel – FREE Template
Do you want to calculate loan amortization schedule in Excel? We can use PMT & SEQUENCE functions to quickly and efficiently generate the full loan amortization table for any number of years.
Who went to both USA & UK? [Excel Challenge]
How about a fun Excel challenge? I have data in below format in the table named trips I want to know which employees visited both USA & UK? How would you solve this problem? Post your solutions in the comments. Need sample data & my solution? Click here to download the file. Want more challenges […]