New to Excel? Looking for a tip? How about a tip so mind-blowingly advanced as to qualify as a magic trick? You're in luck. In this Excel tutorial from ExcelIsFun, the 538th installment in their series of digital spreadsheet magic tricks, you'll learn how to create dynamic sub tables based on master sheet array as well as how to create array formulae quickly with the Drill-Through method. All this is accomplished with recourse to the COUNTIF, IF, ROWS, INDEX, SMALL, ROW functions.
- Hot
- Latest
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Repeat each successive date in an Excel date column
-
How To:
Insert a picture or clip art in MS Word 2007
-
How To:
Integrate Microsoft Access and Outlook 2007
-
How To:
Copy and move worksheets in Microsoft Excel 2007
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create an Excel inventory template with running totals
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Calculate probability in an Excel pivot table
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Add navigation buttons to a form in Microsoft Access
-
How To:
Create a checkbook-balancing formula in Excel
-
How To:
Do bank reconciliation in Microsoft Excel
-
How To:
Find a P-Value with Excel
-
How To:
Generate random numbers (with decimals) in Excel
-
How To:
Create a Basic Attendance Sheet in Excel
-
How To:
Repeat each successive date in an Excel date column
-
How To:
Insert a picture or clip art in MS Word 2007
-
How To:
Integrate Microsoft Access and Outlook 2007
-
How To:
Copy and move worksheets in Microsoft Excel 2007
-
How To:
Measure the spread of a data set with Excel's AVEDEV
-
How To:
Calculate monthly retirement income in Microsoft Excel
-
How To:
Create a pass-fail grade formula in Microsoft Excel
-
How To:
Extract records that meet certain criteria in Excel
-
How To:
Update inventory records by formula in Microsoft Excel
-
How To:
Create an Excel spreadsheet to calculate your GPA
-
How To:
Create an Excel inventory template with running totals
-
How To:
Build a 15-minute schedule in Microsoft Excel
-
How To:
Calculate probability in an Excel pivot table
-
How To:
Instantly Change Blocks of 'CAPITALIZED TEXT' in Microsoft Word to 'Lowercase Letters'
-
How To:
Add navigation buttons to a form in Microsoft Access
-
How To:
Create a checkbook-balancing formula in Excel
-
How To:
Do bank reconciliation in Microsoft Excel
1 Comment
This was very informative and I think I will try this with a few spreadsheets that I have to update.
How can I get in touch with you for assistance with a specific spreadsheet that I am having some problems with.
Tommy
Share Your Thoughts