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 340th installment in their series of digital spreadsheet magic tricks, you'll learn how to use the SMALL and LARGE functions and array syntax to retrieve more than one value.
Just updated your iPhone to iOS 18? You'll find a ton of hot new features for some of your most-used Apple apps. Dive in and see for yourself:
How To:
Generate random numbers (with decimals) in Excel
How To:
Calculate excess over a hurdle in Microsoft Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Create a Tangent Line with Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Find a P-Value with Excel
How To:
Download & install the Microsoft Excel MoreFunc add-in
How To:
Conditionally format at every change in value in Excel
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
List all modes in a multimodal data set in MS Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Force text formulas to wrap with Excel's CHAR function
How To:
Calculate monthly retirement income in Microsoft Excel
How To:
Allow only Monday dates in a cell in Microsoft Excel
How To:
Use the Ribbon interface in Microsoft Access 2010
How To:
Open, close & save documents in MS Word 2007
How To:
Do bank reconciliation in Microsoft Excel
How To:
Generate random numbers (with decimals) in Excel
How To:
Calculate excess over a hurdle in Microsoft Excel
How To:
Create a Basic Attendance Sheet in Excel
How To:
Create a Tangent Line with Excel
How To:
Hide scroll bars, sheet tabs & charts in Excel
How To:
Download & install the Microsoft Excel MoreFunc add-in
How To:
Find a P-Value with Excel
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
How To:
Calculate bonuses based on years worked in MS Excel
How To:
Conditionally format at every change in value in Excel
How To:
List all modes in a multimodal data set in MS Excel
How To:
Multiply column times row with Transpose in MS Excel
How To:
Clear data & cell contents in Excel using a macro
How To:
Create a sudoku puzzle in Excel with array formulas
How To:
Calculate monthly retirement income in Microsoft Excel
How To:
Force text formulas to wrap with Excel's CHAR function
How To:
Use the Ribbon interface in Microsoft Access 2010
How To:
Allow only Monday dates in a cell in Microsoft Excel
How To:
Open, close & save documents in MS Word 2007
How To:
Enter formulas in Excel with a macro
Be the First to Comment
Share Your Thoughts