New to Microsoft Excel? Looking for a tip? How about a tip so mind-blowingly useful as to qualify as a magic trick? You're in luck. In this MS Excel tutorial from ExcelIsFun, the 196th installment in their series of digital spreadsheet magic tricks, you'll learn how to find and count the longest and shortest words/strings with the MAX, MIN and LEN functions in an array formula.
Follow WonderHowTo on Facebook, Twitter, Pinterest, and Flipboard
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Compare two lists and extract the new values in Excel
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Extract part of a table from a larger table in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
How To:
Insert macro from the Internet into an Excel worksheet
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Extract records that meet certain criteria in Excel
How To:
Create a Tangent Line with Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Find critical values with T functions in MS Excel
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
How To:
Calculate Commission Based on Varying Rates in Excel
How To:
Find a P-Value with Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Enter formulas in Excel with a macro
How To:
Compare two lists and extract the new values in Excel
How To:
Sum dollar amounts from a column in Micrsoft Excel
How To:
Extract part of a table from a larger table in Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a percentage frequency table in Microsoft Excel
How To:
Use AGGREGATE instead of SUBTOTAL in MS Excel 2010
How To:
Insert macro from the Internet into an Excel worksheet
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Calculate a bonus in Microsoft Excel
How To:
Conditionally format at every change in value in Excel
How To:
Extract records that meet certain criteria in Excel
How To:
Create a Tangent Line with Excel
How To:
Summarize survey results with a pivot table in Excel
How To:
Find critical values with T functions in MS Excel
How To:
Calculate APR, EAR & period rates in Microsoft Excel 2010
How To:
Calculate Commission Based on Varying Rates in Excel
Be the First to Comment
Share Your Thoughts