Videos tagged with formula
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.
Learn Excel Episode 1039: Round & Round
Gopal asks how to round a number up to the next whole number. Episode 1039 takes a look at several different functions available for rounding numbers in Excel.
Learn Excel Episode 1037: 2nd Smallest
If you need to find the smallest value in a range, you would use MIN. Episode 1037 will show you how to find the second smallest value, third largest value and so on. Also in this episode, sort with a formula.
Learn Excel Episode 1034: Count Visible Rows
Isabel asks how to count only the visible entries in a range. =COUNTA() is returning all of the values. Episode 1034 will show you how to count or sum the visible rows in a range.
Learn Excel Episode 1029: British Cattle (Really)
Yes - a podcast of use to 10,000 British Cattle Farmers but of no use to anyone else. Actually...it is a fun challenge. Play this one to see the problem then see if you can come up with a formula to extend the fine numbering system used for British Cattle! Episode 1029 will show you how.This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two mi...
Learn Excel Episode 916: AutoNumbering & Twitter
The day after Christmas and you are at work? Or just checking out the podcast on your new iPod? Let's do a social networking experiment. Plus...how to autonumber rows. And...a podcast special at the MrExcel store. Watch it all in Episode 916.
Learn Excel Episode 902: Decimal Hours
Calculate time difference and show the result as a decimal number of hours. Episode 902 will show you how.
Learn Excel Episode 899: Minus Minus
Kim asks about the minus minus in certain formulas. In Episode 899, I will break one of those formulas down and show exactly why people use the minus minus.
Learn Excel Episode 889: Concatenated Key
You need to do a VLOOKUP that will look up two values from a table. In Episode 889, I will show a method using a concatenated key field to enable VLOOKUP to work.
Learn Excel Episode 890: Offset as TableArray
An alternative to Episode 889...If you need to match two sorted columns with a VLOOKUP, you can make the table array be dynamically calculated with the OFFSET function. Episode 890 shows you how.