Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description
Download Files: https://people.highline.edu/mgirvin/YouTubeExcelIsFun/MrExcelExcelisfunTrick180.xlsm
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use formulas to extract dates that are inconsistent in form (some are listed as Month and Year, some are listed as Day, Month and Year) from a text description. See the functions: SEARCH, AGGREGATE, MID, ISNUMBER, IF, TRIM and SUBSTITUTE. Learn about a Function Argument Array Operation. This is an Array Formula.
Видео Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description канала excelisfun
Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htm
Bill Mr Excel Jelen and Mike excelisfun Girvin show how to use formulas to extract dates that are inconsistent in form (some are listed as Month and Year, some are listed as Day, Month and Year) from a text description. See the functions: SEARCH, AGGREGATE, MID, ISNUMBER, IF, TRIM and SUBSTITUTE. Learn about a Function Argument Array Operation. This is an Array Formula.
Видео Mr Excel & excelisfun Trick 180: Extract Varying Dates From Description канала excelisfun
Excel 2016 Excel 2013 excelisfun Bill Mr Excel Jelen Mike excelisfun Girvin Highline Community College Slaying Excel Dragons Ctrl Shift Enter Mastering Excel Array Formulas VBA Extract dates Get Dates from Text Extract Dates from Text Find Dates SEARCH function AGGREGATE function MID function ISNUMBER function IF function TRIM function SUBSTITUTE function Array Formula Function Argument Array Operation.
Комментарии отсутствуют
Информация о видео
14 апреля 2017 г. 17:10:50
00:14:48
Другие видео канала
