Excel Flash Fill April 22, 2019April 22, 2019 KCR Posted in ExcelTagged Flash FillLeave a Comment on Excel Flash Fill View Article
The Basics: SUM, COUNT, MAX, And MIN April 21, 2019April 22, 2019 KCR Posted in ExcelTagged COUNT, MAX, MIN, SUMLeave a Comment on The Basics: SUM, COUNT, MAX, And MIN View Article
EMT1100 – Cross Tabulated Lookup April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged IF, INDEX, ISNUMBER, MATCH, SUMPRODUCTLeave a Comment on EMT1100 – Cross Tabulated Lookup … View Article
EMT1099 – Compare 2 Lists with Semi-colon Discrepancies April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged ISNUMBER, MATCH, SUBSTITUTELeave a Comment on EMT1099 – Compare 2 Lists with Semi-colon Discrepancies … View Article
EMT1098 Compare Two E-mail Lists with Formula: E-mail In List? Not In List? April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged ISNA, ISNUMBER, MATCH, NOTLeave a Comment on EMT1098 Compare Two E-mail Lists with Formula: E-mail In List? Not In List? … View Article
EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged AND, Conditional Formatting, COUNTIFS, OR, SUMIFS, SUMPRODUCTLeave a Comment on EMT1097 AND & OR Criteria Together for Counting, Adding, Conditional Formatting … View Article
EMT1096 Extract Date from Middle of Description, Better Formula April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged MID, SEARCH, SUBSTITUTELeave a Comment on EMT1096 Extract Date from Middle of Description, Better Formula … View Article
EMT1095 Count Doubles & Triples Using FREQUENCY function April 13, 2019April 21, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged COUNT, COUNTIF, FREQUENCYLeave a Comment on EMT1095 Count Doubles & Triples Using FREQUENCY function … View Article
EMT1094 Wildcards for Sheet References and INDIRECT function April 13, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged INDIRECTLeave a Comment on EMT1094 Wildcards for Sheet References and INDIRECT function … View Article
EMT1093 Extract Date from Middle of Description April 13, 2019April 22, 2019 Mike Girvin Posted in Excel, Excel Magic TrickTagged LEFT, REPLACE, SEARCH, SUBSTITUTE, Text To ColumnsLeave a Comment on EMT1093 Extract Date from Middle of Description … View Article