Denise from Orlando checks in with a cool trick for converting text to numbers using the minus minus trick. Episode 1210 shows you how. 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.
Double the Power of the Recently Used File List. Episode 105 will teach you an easy customization to improve the recently used file list in Excel. Learn Excel 97-2007 from MrExcel.
Alternate shortcut keys....other ways to undo. Other ways to copy and paste. How to edit a cell comment. How to insert a new worksheet. And, a quest...how to assign F1 to do F2. Episode 1209 shows you how. Learn Excel 97-2007 from MrExcel.
Patrick asks how Excel chooses to assign icons to values when you use the icon set feature. Episode 1208 explains how the icon sets work and how to change the default behavior. Learn Excel 97-2007 from Mrexcel.
This problem is similar to episode 1206, but this time the question is how to highlight the entire row of the record with the largest value. Episode 1207 shows you how. Learn Excel 97-2007 from MrExcel!
Today's Time Warp Wednesday Podcast: Secret Menu Items - Episode 104 will reveal how to unlock powerful menu items in Excel.
How can you highlight the lowest value in each row? Episode 1206 shows you the answer! Check out 376 other tips - Learn Excel 97-2007 from MrExcel.
Create a Top 10 in a Pivot Table report where the grand total shows the total for all customers, not just the top 10.
Learn Excel 97-2007 from MrExcel. Get the book!
Solving the same problem from episode 1203, doing a VLOOKUP that matches two columns, but without using a concatenated key. This solution uses the OFFSET function to dynamically change the position of the lookup table.
