Learn a little about Customizing your VBA. We have a Macro that runs on the current cell; JK wants the macro to run for each cell in Column A. Today, in Episode #1481, Bill shows us how calculate the number of cells we need to check and then loop the macro.

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Today, lets consider this question: Someone has a threshold value of $25000 in cell E1. We want to add up all the values in A2:A8 that are over the threshold. But...as a twist, how do we work with only those amounts in excess of the threshold? In Episode #1480 Bill shows how this can be accomplished.

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

YouTube viewer Bill sent in a question: "How can change column widths when I am half way down the column?" Bill is using Mac Office 2008. Though there isn't a way to do what Bill is asking, MrExcel offers up a possible solution to this challenge in Episode #1479.

…This episode is the video podcast companion to the book, “Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Last weeks Dueling Excel Episode #1473 looked at Ranking Ties by Weight. Today, in Episode #1478, Bill shows a method using a temporary column.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

It's the eve of the holiday shopping season. And while we don't hope to have anyone camping out at MrExcel overnight, here are some of the deals that we are running starting Thursday, 24-November-2011 and through Monday 28-November-2011. Don't miss out on these Excel-lent opportunities from MrExcel.com!

…This blog and video podcast are sponsored by the book, Learn Excel 2007 through Excel 2010 from MrExcel and The MrExcel Excel Store!

Learn Excel 2007 through Excel 2010 from MrExcel - Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

A Challenge from none other than Bob Umlas - author of "Excel Outside The Box: Unbelievable Excel Techniques". Bob wants to Number Rows, but ignore the 'Hidden' Rows. In Episode #1476 Bill looks to a New Function for Excel 2010: " =AGGREGATE" Learn about it with the 'Learn Excel from MrExcel' Video Podcast.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

A facebook posting asks how to convert a column of 7 digit numbers (ie, 1234567) into the format of "Lat 12 34.567". The answer is easier than you might think. In Episode #1476, Bill shows us a non-formula way to answer the question and get the result.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

Superbeast326 at YouTube asks if there is a way to add the current date to the right of any 'Yes' entries in a spreadsheet; if a cell is marked 'Yes', then I want the cell to the right of that cell to show the date. Using a simple 'Event Handler' macro, in Episode #1474, Bill creates a means to answer the question and record the date.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

Dueling Excel looks at Scores and Tie Breaking. In this example, When there is a tie, we want to award the Highest Rank to the Largest Weight. Quite simply, after ranking a column with ties, we want to break the tie based on another column. Today, in Episode #1473, Mike “ExcelisFun” Girvin and Bill “MrExcel” Jelen offer their solutions to this challenge.

Dueling Excel Podcast #91…This episode is the video podcast companion to the book, “Slaying Excel Dragons: A Beginners Guide to Conquering Excel’s Frustrations and Making Excel Fun“, by Mike Girvin and Bill Jelen. [Currently available in eBook / Print Edition and as a DVD Bundle]

and

“Learn Excel 2007 through Excel 2010 from MrExcel”. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Herbie has a Calendar spreadsheet being populated by a huge concatination formula. He asks if there is a way to combine Wrap Cells and Shrink to Fit as he works in the calendar. In Episode #1472 Bill shows us one way to accomplish this.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us!

Choose random weeks from the Data Set, but do it without repeating a week. In a revisit to Episode #1469, how will Bill assure that there are no repeats in the Random selection? Follow along with Episode #1471 today to learn the answer and solve the challenge.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us

Patrick has a weekly Expense Ledger Spreadsheet set up; he wants to create a Macro to copy the Totals from Report 1 to a corresponding Week Number Row on the Summary worksheet. This Macro has to use the FIND command in VBA to figure out where to paste special the data. Follow along with Episode #1470 as Bill shows us how to accomplish the task.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us

A YouTube viewer wants to find a way to generate random weeks over the next 6 months. In Episode #1469, Bill “MrExcel” Jelen – using TODAY, WEEKDAY, and RANDBETWEEN Functions – shows us a Formula to calculate random weeks for the next 6 months or year.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Shaun has a beautiful spreadsheet to calculate staffing levels and expense.He needs to multiply shift length by the number of staff and the answer that he is getting is . . . immaterial to the task at hand. With a few changes in the Formula and Cell Formats, Bill shows us in Episode #1468 how to get the real resulting Total Hours and Cost.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

Every few months Bill receives a call or an email from someone stating that their Formulas are 'changed' and that the Alpha Columns of the worksheet have been changed to Numbers. What happened? "R1C1" is the answer. Follow along with Bill in Episode #1467 to find out what happened and how to correct it.

…This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill’s book!

“The Learn Excel from MrExcel Podcast Series”

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!