Excel Is Fun

Excel Magic Trick 1166

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 [Read More >>>]

Excel Is Fun

Excel Magic Trick 1163

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 [Read More >>>]

Dueling Excel

Dueling Excel 030

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 [Read More >>>]

Dueling Excel

Dueling Excel 026

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 [Read More >>>]

Dueling Excel

Dueling Excel 023

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

Excel Is Fun

Excel Magic Trick 1114

DESCRIPTION See how to create formula for Sequential & Repeating Numbers: 18400 1, 18441 1, 18442 1, 18443 2, 18444 2, 18445 2, 18446 3…. See formula that uses the functions ROWS, INT and the [Read More >>>]