Mike from OK City asks how to delete all names in a workbook. In Episode 904, I will show you a way to delete all names or to delete only the invalid names.
This video podcast is the companion to the book, Learn Excel 97-2007 from MrExcel.
-
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.
Morne sends in a question about highlighting records that fall on a weekday. There are a couple of approaches. Episode 901 shows you how.
Calculate time difference and show the result as a decimal number of hours. Episode 902 will show you how.
Continuing yesterday's discussion about minus minus, we'll take a look at using SUMPRODUCT vs the new Excel 2007 SUMIFS to solve the multiple conditional sum problem. Episode 900 shows you how.
Beardless Rot wants to know how to sort filtered data so that the top 10 autofilter will show items high-to-low. Episode 903 will show you how.
