Excel Is Fun

Excel Magic Trick 1272

February 20, 2017 0

DESCRIPTION Max Value for Each Day Of The Week: AGGREGATE Function (2 Methods) Learn how to find the max value for each day of the week using the Excel 2010 or later function AGGREGATE. See […]

Excel Is Fun

Excel Magic Trick 1262

January 16, 2017 0

DESCRIPTION Convert Times Values to HHMM Text or Text HHMM Values to Time Values Learn how to use the TEXT function and custom Number Formatting to: (00:12) Convert Times Values to HHMM Text with TEXT […]

Excel Is Fun

Excel Magic Trick 1258

January 2, 2017 0

DESCRIPTION Add Spaces Between Digits: Custom Number Format & TEXT Function Learn how to use Custom Number Format in Excel to display numbers with spaces and to convert numbers to text with the TEXT Function. […]

Dueling Excel

Dueling Excel 119

November 16, 2016 0

DESCRIPTION Sorting For Plant List, Sort by Month and Day Only See Mr Excel and excelisfun use two methods to override the Sort feature’s default Date sorting technique so that we can sort just by […]

Dueling Excel

Dueling Excel 107

September 23, 2016 0

Count Between Words DESCRIPTION See Mr Excel and excelisfun use three methods to add a leading zero at front and a dash in middle of a number that may be of variable length: 1. Formula […]

Dueling Excel

Dueling Excel 73

April 13, 2016 0

Coax Time Value From Text: MOD, LEFT, RIGHT, TEXT, MOD Functions DESCRIPTION See Mr Excel and excelisfun use the functions MOD, LEFT, RIGHT, TEXT, TIMEVALUE, and MOD to coax a time value from a time […]

Excel Is Fun

Excel Magic Trick 1196

March 14, 2016 0

YYMMDD Text Dates To Serial Number Dates? 2 More Formulas & Other Tips… DESCRIPTION See how take two columns of county numbers and kip codes and show unique list of county codes vertically, and then […]

Dueling Excel

Dueling Excel 68

March 9, 2016 0

Count Dates in Column That Match Year and Month Criteria DESCRIPTION See Mr Excel and excelisfun Count Dates in Column That Match Year and Month Criteria with the functions: DATEVALUE, EOMONTH, LOOKUP, SUM, TEXT, COUNTIFS […]

Excel Is Fun

Excel Magic Trick 1195

March 7, 2016 0

Are YYMMDD Text Dates 1900 or 2000? Formula or Text To Columns Solution? DESCRIPTION See how to deal with a Text Date in the form YYMMDD when some of the years are 1900 and some […]