Excel 2013

Learn Excel – “Use Solver with VBA”: Podcast #1830


Haizen has to arrange transport for ‘N’ employees where ‘N’ can be 1 to 500. There are three types of vehicles available with different capacity and different cost. He wants a Formula for Back

Learn Excel – “15 Years Ago Today: Convert Date to Month”: Podcast #1829


It was the Saturday before Thanksgiving in 1998 when I opened Notepad and launched the first ‘Tip of the Week’ at MrExcel.com. Using the Wayback Machine, see how the tip for Converting Daily Dates to Months holds up 15 years later. Lets take a look at Episode #1829 and see… Back

Learn Excel – “Make Ctrl+V be Paste Special”: Podcast #1828


Seckin set up a Worksheet for his co-workers with great Conditional Formatting. Unfortunately, the co-worker uses Ctrl+V instead of Paste Special Values, Back

Learn Excel – “Show AutoFilter Selected Items”: Podcast #1827


Mark G has an AutoFilter outside the print range and wants to show what is selected in the AutoFilter inside the print range. Excel 2013 Table Slicers could do this, but Back

Learn Excel – “Is Text in ANY Column?”: Podcast #1826


Two similar questions: (1) Can I count how many Rows contain certain Text in any Column? (2) Can I Filter to only Rows that have the selected Text in Back

Learn Excel from MrExcel