A question from YouTube about the Excel RATE function not appearing to work. The function does work, but since it returns the rate per period instead of the annual rate, the answer provided by the function might appear to be wrong.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Fred used Data Validation to select a model from the list. Once you select the model, how do you pull all of the field data forward to Sheet1? There are many approaches you could use. Episode 1803 shows how to use MATCH and INDEX.
Szilvia Juhasz guest hosts today's Learn Excel podcast - how to use fun fonts in your Excel dashboards. Thanks to Szilvia for guest hosting.
You have serial numbers like AA10D, AA11D and want to fill to AA12D, AA13D, and so on. The Excel Fill Handle won't do this. Learn how to solve it with a formula.
Create an average by each category that will work before AVERAGEIF came along in Excel 2007. Bill and Mike offer a pivot table, and two different formulas.
Using conditional formatting to create an hourly Gantt chart in Excel.
Ian wrote in looking for an array formula that would build a unique list of managers who belong to a selected VP. Since Ian has Excel 2013, I propose using Slicers instead of the insanely difficult array formulas.
jiayouluckystar from YouTube asks about controlling the word wrap of long labels along the x-axis. While the chart format dialog offers no control over word wrap, it can be done.
Dalia tried to use the Excel Interactive View to show data on the web, but she needs to show/hide columns instead of rows. Today, a way to filter by column using two pivot tables and a slicer. To try out the web app: http://tinyurl.com/lqwxwho
