If you don't have the Filter function in Excel, you need to check out this easy formula approach to get multiple match results in Excel. Download the workbook and use the version that fits your example best.
Create multiple dependent drop-down lists in Excel that you can copy to every row. You'll also learn how to exclude the blank cells on the bottom to make sure each list is restricted to the number of categories available.
Create an automatically sorted Excel bar chart that ALSO lets you hide and show categories based on a flag in the cell. It's super easy with Excel dynamic arrays.
Check out this Excel formula hack to count text cells only. This mysterious syntax, excludes blank cells, numbers and also cells with formulas that result in an empty string.
Time Value of Money “A dollar today is worth more than a dollar tomorrow.” It’s a saying that is true for any business as well as your own personal finances. It’s a simple principle that has a fancy name…Time Value of Money.
Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.
In the beginning days for any Excel user, there seems to be an unavoidable event that occurs. You’re cruising along typing in data and writing simple formulas. Then you are shown that a formula can be repeated across many rows of data using Fill Series or copy/paste. But then, IT happens!
Sometimes the data you copy or import into Excel has stubborn spaces that can't be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.
With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.
Excel Calendar with Holidays and Appointments This week’s post is a special post because it comes directly from the super-brain of one of our XelPlus community members, Adam Weaver. Adam holds both a PMP certification (Project Management Professional) and an RMP certification