Dueling Excel

Dueling Excel 134

March 22, 2017 0

DESCRIPTION Merge Product and Sub-Product Text; VBA or Wild INDEX Formula See Mr Excel and excelisfun use two methods to take a table of product names, each with 6 sub-products, and unwind the table to […]

Dueling Excel

Dueling Excel 132

March 8, 2017 0

DESCRIPTION See Mr Excel and excelisfun use two methods to convert from the numbers 10.1 and 10.2 to 10.333 and 10.667, and the reverse using two methods: 1. DOLLARDE and DOLLARFR functions 2. MOD and […]

Excel Is Fun

Excel Magic Trick 1250

November 24, 2016 0

DESCRIPTION Add Times to Get Total Minutes & Seconds From Downloaded Music Data Learn how to add times to show total minutes and seconds for copy and pasted downloaded music data. Learn about Time Math, […]

Excel Is Fun

Excel Magic Trick 1236

October 6, 2016 0

DESCRIPTION Count Numbers that Contain Whole Number 4: COUNTIFS or SUMPRODUCT? Learn how to count numbers that contain the whole number 4: (00:11) Problem Introduction (01:05) COUNTIFS formula that uses Cell References, Comparative Operators and […]

Excel Is Fun

Excel Magic Trick 1168

October 12, 2015 0

Get Time Value From Date Time Value (2 Formula Examples) DESCRIPTION See how to Get the Time Value from a Date Time Value: (00:08) What is a Date Time? What is a Time in Excel? […]

Excel Is Fun

Excel Magic Trick 1166

October 5, 2015 0

Count Dates From Date-Time Values: COUNTIFS or PivotTable? DESCRIPTION See how to Count Dates From Date-Time Values: COUNTIFS or PivotTable: (00:00) Look back to EMT 1163 to look at SUMPRODUCT and INT formula (00:45) COUNTIFS […]

Excel Is Fun

Excel Magic Trick 1163

September 24, 2015 0

COUNTIFS For Dates, When Dates Have Time Value Too? COUNTIF too. DESCRIPTION See how to: (00:10) COUNTIFS with Date Criteria that is matched up against a column with Data Times will not work. (00:55) Examine […]

Dueling Excel

Dueling Excel 030

July 1, 2015 0

Count Bills for Money Transaction DESCRIPTION See Mr Excel and excelisfun create formula that will take a dollar amount and count how many $100 bills, how many $50 bills, etc. are needed for the minimum […]

Dueling Excel

Dueling Excel 026

June 3, 2015 0

Randomize Between 2 Dates DESCRIPTION See Mr Excel and excelisfun create random dates between upper and lower dates using the 4 different formulas that use functions such as RANDBETWEEN, RAND, INT and DATE. See formulas […]

Dueling Excel

Dueling Excel 023

May 23, 2015 0

Excel 2010 New Functions DESCRIPTION See Mr Excel and excelisfun show off the new Excel 2010 functions: NETWORKINGDAYS.INT, RANK.AVE, PERCENTILE.EXC, CONFIDENCE.T, T.DIST, T.DIST.RT and T.DIST.2T. WORKBOOKS