Videos tagged with MrExcel

Dak asks how to take a long cell entry and to split it into 20 character entries going down a column without using wrap text. Episode 1102 shows a couple of ways to solve the problem.

Gary, Jamie, Monish and Michael all check in with ideas on why to use the Split command. Episode 1101 is a follow up to last Wednesday's podcast 1098.

DRG asks how to use COUNTIF to find records that match a range. Unfortunately, it can not be done with COUNTIF. In Episode 1100, Bill and Mike compare six solutions.

Pablo sends in a cool tip for using Spearing Formulas. Episode 1099 shows you how.

What the heck is the SPLIT command for? Episode 1098 wonders about this.

Shift-Del sends in some alternative formulas to solve the problem from episode 1043. To see uses of SUBSTITUTE and REPLACE in Excel, check out Episode 1097.

Your recorded macros might not work if someone renames a worksheet. Rather than use the worksheet name, use the code name for the worksheet. This name can never be changed and is more reliable. Episode 1096 shows you how.

Mike and Bill offer different ways of generating a random date between two dates. Episode 1095 shows you how.

Excel 2007 offers a cool trick to replace Freeze Panes. Episode 1094 shows you how.

Mike from Arizona asks how to create a revenue bridge chart. This is similar to a waterfall chart, except some of the points are negative. Episode 1093 will show you how to create this chart.