Excel Magic Trick 585: Deleting Content, Cells, Formatting & The Problem with Right-Click Delete

Excel Magic Trick 586: Count Records 3 Criteria Including Contains Text & SEARCH function

Excel Magic Trick 587: Conditional Formatting 3 Criteria including SEARCH for Text Contains Criteria

Excel Magic Trick 588: 2 VLOOKUP Functions looking into 2 Different Tables

Excel Magic Trick 589: Stem & Leaf Chart for Decimals - Array Formula - Statistics

Excel Magic Trick 590: Nested IF function Convert From Actual Days to Billed Days

Excel Magic Trick 591: Paste Special Operations Add & Multiply

Excel Magic Trick 593: Mondays Only Data Validation using Custom Formula with WEEKDAY function

Excel Magic Trick 596: Counting With 4 Criteria Including All Criteria As A Possibility

Excel Magic Trick 592: Extract Word That Occurs Most Frequently - MODE for Word - Data Array Formula

Excel Magic Trick 595: DGET #NUM! Error same as Advanced Filter Duplicate Problem Extract Record

Excel Magic Trick 597: Counting With 4 Criteria Including All Criteria Robust Formula

Excel Magic Trick 598: Hours Worked In Day Including Lunch Breaks

Excel Magic Trick 594: How Old Are You? DATEDIF Function

Excel Magic Trick 599: ROUND Only The Total Column Using SUM & ROUND Array Formula

Excel Magic Trick 600: Convert Hours to Days & Hours using MOD & INT functions

Excel Magic Trick 601: VLOOKUP & IF functions for Bonus Based On Years Worked

Excel Magic Trick 602: SUMIF Does Lookup? Total Sales Array Formula w 1 Criteria SUMIF Function

Excel Magic Trick 603: Why 100*1.1 = 110 Means Increase by 10%

Excel Magic Trick 604: Mixed Cell References In Formulas - Budgeted Income Statement

Excel Magic Trick 605: IF Function to Fill In Column With Missing Values Paste Special Values

Excel Magic Trick 606: INDEX & MATCH Two Lookup Values

Excel Magic Trick 607: Match 3 Lists: Matching Accounting Documents PO, Receiving & Invoice

Excel Magic Trick 608: Array Formula To Return Multiple Items - List Students With Free Periods

Excel Magic Trick 609: Array Formula To Return Multiple Items - List Periods That Students Have Free

Excel Magic Trick 615: Adding With Approximate Criteria SUMIF Function and * Wildcard

Excel Magic Trick 616: LARGE & SMALL Functions (8 Examples)

Excel Magic Trick 617: Fiscal Years Not Ending Dec 31 - Total Sales & Year Over Year Formulas

Excel Magic Trick 618: Keyboard Shortcut For Date And Time In Same Cell

Excel Magic Trick 619: Space in Cell Causes Trouble in Formulas. Replace, COUNTA, CLEAN, TRIM

Excel Magic Trick 620: Count Unique Items in List - Robust Formulas & A Few Array Formula Tricks

Excel Magic Trick 621: Conditional Formatting Unique Items With One Criteria

Excel Magic Trick 622: Array Formula to Return Even Row Data Only

Excel Magic Trick 623: PayDay LoansAre Bad Finance -- APR & EAR & Amortization Table

Excel Magic Trick 624: Hours Worked Part Day Shift & Part For Night Shift MEDIAN Function for Hurdle

Excel Magic Trick 625: INDIRECT SUBSTITUTE SUBSTITUTE Silly Two Way Lookup Formula

Excel Magic Trick 626: Time Gantt Chart -- Conditional Formatting & Data Validation Custom Formulas

Excel Magic Trick 627: FREQUENCY Array Function (10 Examples)

Excel Magic Trick 628: VLOOKUP Data Validation IF Function Date Math Total After Discount Template

Excel Magic Trick 629: HR Salary Calculation Based On Relevant Years Worked (2 methods)

Excel Magic Trick 630: Drag Formula Without Dragging Keyboard Shortcuts Through Huge Range

Excel Magic Trick 631: Conditional Formatting Invoices 90 Days Past Due

Excel Magic Trick 632: Count Dates Within Given Year From A List Of Dates With Different Years

Excel Magic Trick 633: Conditional Format Dates for Year From A List Of Dates With Different Years

Excel Magic Trick 634: Text to Text or Number to Number Matches for Logical Formulas

Excel Magic Trick 635: Find Perfect Match In Column Using IF & AND functions

Excel Magic Trick 636: Dynamic Frequency Table & Histogram Chart

Excel Magic Trick 637: Lookup A Chart -- Defined Names, INDIRECT function and Formulas In Pictures

Excel Magic Trick 638: Two Horizontal Axes for A Chart.

Excel Magic Trick 639: Approximate Match Lookup with Unsorted Column Across Multiple Columns

Excel Magic Trick 640: VLOOKUP and Conditional Formatting to Highlight Row with Low Rank

Excel Magic Trick 641: Create PivotChart in 1 click (Great Keyboard Shortcut for Charts)

Excel Magic Trick 642: SUMIFS function or PivotTable For Household Budget Summary Table

Excel Magic Trick 643: IF Function to Pull Data From A Different Column

Excel Magic Trick 644: Recorded Macro And Formulas To Re-Arrange Data Set

Excel Magic Trick 645: CUMIPMT Function: Cumulative Interest For A Loan

Excel Magic Trick 646: VLOOKUP to add column of categories to Apparel Data Set

Excel Magic Trick 647: Dynamic Line Chart For Cash Balance using OFFSET function

Excel Magic Trick 648: Interesting Formula To Create A Data Set ROWS, COLUMNS and CAR functions.

Excel Magic Trick 649: Formula to increment number pattern 1,1,1,2,2,2,3,3,3...

Excel Magic Trick 650: Formula To Extract All Rows In Data Set Into 1 Column INDEX function

Excel Magic Trick 651: Comparative Operators & Logical Formulas

Excel Magic Trick 652: Boolean Logic for Logical & Array Formulas

Excel Magic Trick 653: Boolean Math Bonus Instead of IF Function

Excel Magic Trick 654: Charts: Line & X Y Scatter

Excel Magic Trick 655: Frequency Polygon Line Chart

Excel Magic Trick 656: Excel Will Talk To You

Excel Magic Trick 657: EOMONTH function For Invoices, Financials, and Quarterly Reports

Excel Magic Trick 658: COUNT Vs. COUNTA function

Excel Magic Trick 659: Advanced Filter Using Formula Criteria to Extract Sample Data

Excel Magic Trick 660: Advanced Filter Unique Records Only

Excel 2010 Magic Trick 661: AGGREGATE function Contains 19 different functions

Excel 2010 Magic Trick 662: AGGREGATE function Ignores Hidden Rows for Calculations

Excel 2010 Magic Trick 663: AGGREGATE function Ignores Error Values for Calculations

Excel 2010 Magic Trick 664: AGGREGATE function Ignores Nested SUBTOTALs for Calculations

Excel 2010 Magic Trick 665: AGGREGATE function Ignores Filtered Values When Making Calculations

Excel 2010 Magic Trick 666: AGGREGATE Function Array Formula #1 Single Cell Array Formula

Excel 2010 Magic Trick 667: AGGREGATE Function Array Formula #2 Return 5 Largest Values

Excel 2010 Magic Trick 668: AGGREGATE Function Array Formula #3 Calculate 90 Percentile CPA Scores

Excel 2010 Magic Trick 669: AGGREGATE function Can Not Handle 3-D Cell References

Excel 2010 Magic Trick 670: AGGREGATE Function Array Formula #4 Extract Records 1 criterion

Excel 2010 Magic Trick 671: AGGREGATE function Array Formula #5 Extract Records 2 criteria

Excel 2010 Magic Trick 672: AGGREGATE function Replaces SMALL Function Array Formula

Excel Magic Trick 673: Varying Commission Rate Lookup Formula SUMPRODUCT Amazing Solution!!

Excel Magic Trick 674: OR Criteria Counting 3 Examples COUNTIF, SUMPRODUCT & SUM-COUNTIF

Excel Magic Trick 675: Double VLOOKUP Custom Formula Dynamic Data Validation

Excel Magic Trick 676: Defined Name Dynamic Range Formula (column number varies) INDEX Function

Excel Magic Trick 677: AVERAGE Last 3 Scores -- Mr Excel Message Board Array Formula

Excel Magic Trick 678: SUM only Values After Deadline Dynamic Range using INDEX Function.

Excel Magic Trick 679: Adding Yearly Totals From Monthly Data - Date Formatting Trouble (2 Examples)

Excel Magic Trick 680: Add A Scenario Button To Toolbar or Ribbon Excel 2010

Excel Magic Trick 681: Find Smallest Number That Is Greater Than Zero Array Formula

Excel Magic Trick 682: Averaging Times Entered As Text (3 Examples) Array Formula

Excel Magic Trick 683: 3 AND criteria & 3rd AND has OR criteria -- Add, Count & Conditional Format

Excel Magic Trick 684: VLOOKUP 1 item & Add Values from Multiple Rows/Columns - HLOOKUP

Excel Magic Trick 685: Conditional Format For Alternative Rows

Excel Magic Trick 686: Fill Column & Concatenate With LOOKUP Last Word Expandable Range Trick

Excel Magic Trick 687: Exclude Values Less Than Zero From Non-Contiguous Ranges - Amazing!

Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add

Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo

Excel Magic Trick 690: Extract Unique Records Based on 2 Columns, List Values Horizontally

Excel Magic Trick 691: Look At Cell C2 No Matter How Many Rows Or Columns You Insert Or Delete

Excel Magic Trick 692: More About Incrementing Numbers In Formulas

Excel Magic Trick 693: HOW Long To Double Your Money: NPER function or Rule of 72.

Excel Magic Trick 694: SUMIF Can't Handle Arrays. SUMIF(YEAR(A2:A10),2010,B2:B10) Won't Work

Excel Magic Trick 695: Allocate Total Costs across Categories Including Extra Pennies

Excel Magic Trick 696: Identify First Occurrence In Column (5 methods)

Excel Magic Trick 697: Extract Month Year Records From Transactional Data - 3 Methods

Excel Magic Trick 698: Extract Unique Items w Formula For Data Validation Drop-Down List

Excel Magic Trick 699: VLOOKUP Mixed Number & Letter Partial Text Extract For Lookup Value

Excel Magic Trick 700: Return Every Other Cell (Cell Reference That Skips Columns) INDEX Function

Excel Magic Trick 701: Take Table Of Values and Place In Column With Formula

Excel Magic Trick 702: VLOOKUP Return Two Values to One Cell or Two Cells

Excel Magic Trick 703: Extract Records Multiple Criteria (AND OR logic) Filter, Formula, Adv. Filter

Excel Magic Trick 704: Analyzing Problem and Building Robust Solution.

Excel Magic Trick 705: Keyboard Shortcut for Finding Formula Dependents and Precedents

Excel Magic Trick 706: Extract Number From Cell With A Time, A Dash and A Number

Excel Magic Trick 707: RANK with Criteria - SUMPRODUCT

Excel Magic Trick 708: Lookup Multiplying -- SUMPRODUCT, Boolean, & INDEX MATCH solution

Excel Magic Trick 709: Defined Name Dynamic Range Formula w Relative References & Data Extract

Excel Magic Trick 710: average with 3 Criteria Using PivotTable Pivot Table

Excel Magic Trick 711: Count Employees in a given County Based on Zip Code SUMPRODUCT COUNTIF

Excel Magic Trick 712: Formula To Take Data in Column and Make Proper Table For Name and E-mail

Excel Magic Trick 713: Count Max Number In Succession in Column FREQUENCY function magic!

Excel Magic Trick 714: Three Criteria Lookup Adding SUMIF, INDEX, MATCH, SUMPRODUCT (2 examples)

Excel Magic Trick 715: Take Number with Spaces and Convert to Number

Excel Magic Trick 716: Max of Absolute Values MAX & ABS functions Array Formula

Excel Magic Trick 717: List 2 Same Order as List 2? MATCH and ROWS functions

Excel Magic Trick 718: Calculate Hours Worked (Day or Night Shift) & Subtract Lunch

Excel Magic Trick 719: Comparing Two Lists Trouble 2 Examples (Numbers Not Match Numbers As Text)

Excel Magic Trick 720: Show Records Between 2 Dates: Filter, Logical Formula, Conditional Formatting

Excel Magic Trick 721: Convert Text Time Numbers Without A Colon To Time 0655 into 06:55 AM

Excel Magic Trick 722: Calculate Gross Pay For Week From Time Values In Range & Hourly Wage

Excel Magic Trick 723: COUNTIF Error With Workbook References, Use SUMPRODUCT Instead

Excel Magic Trick 724: VLOOKUP Check If Quantities Are Equal In Two Lists Show Differences If Not

Excel Magic Trick 725: Which Quartile Are You In? INPUT your Score, Formula Says Quartile You Are In

Excel Magic Trick 726: Count 1 For Each Item in List 1 That Is In List 2 No Double Count for Dups

Excel Magic Trick 727: Calculate Hours Worked Night or Day Shift With Break For Lunch

Excel Magic Trick 728: COUNTIF & AND Functions Check Whether 3 Specific People Worked Together

Excel Magic Trick 729: VLOOKUP When Multiple Lookup Items In Cell, LOOKUP & SEARCH functions

Excel Magic Trick 730: SUMIF with Approximate Criteria

Excel Magic Trick 731: Retrieve Cell Address Of Minimum Value In Column

Excel Magic Trick 732: SERIES Chart Function

Excel Magic Trick 733: Expected Returns For Portfolio SUMPRODUCT & MMULT functions

Excel Magic Trick 734: Downloaded Decimal (Percentage) Grades into Actual Integer Grades

Excel Magic Trick 735: Find Max Running Three Week Totals SUBTOTAL / OFFSET Array Formula

Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar

Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem

Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment

Excel Magic Trick 739: Three Ways To Do Double Underline in Excel

Excel Magic Trick 688: Lookup All Values In Expanding Dynamic Row and then Add

Excel Magic Trick 689: Fill Column With 1 to 1000 Two Methods: 1) Series & 2) GoTo

Excel Magic Trick 736: Formula & Conditional Formatting To Show Waste From Cutting Rebar

Excel Magic Trick 737: Sorting Wrecks Formula, Use VLOOKUP function To Solve Problem

Excel Magic Trick 738: Goal Seek, PMT function for Loan Payment, Cash Flows and Balloon Payment

Excel Magic Trick 739: Three Ways To Do Double Underline in Excel

Excel Magic Trick 740: Avoid Errors & Blanks In Chart Using Filter

Excel Magic Trick 741: Avoid Errors & Blanks In Chart Using Formulas & Defined Name Dynamic Ranges

Excel Magic Trick 742: Wrap Text In Chart Label Using CHAR function and Code 10

Excel Magic Trick 743: Conditional Formatting To Match Items In List On A Different Sheet

Excel Magic Trick 744: Break Even Analysis Formulas Chart & Plotting Break Even Point On Chart

Excel Magic Trick 745: Allocating Indirect Expenses to Calculate Departmental Net Income Accounting

Excel Magic Trick 746: Payback Rule Dynamic Single Cell Array Formula LOOKUP function Array Magic

Excel Magic Trick 747: Expected Returns and Standard Deviation Single Cell Array Formula

Excel Magic Trick 748: Count Weekends With No Events Scheduled Formula

Excel Magic Trick 749: Add Yearly Totals From Daily Date Data without SUMIF Function

Excel Magic Trick 750: 7 Days Past Due Conditional Formatting & Logical Formula

Excel Magic Trick 751: Freeze Panes For Large Workbooks Freeze either a Row, Column, or Both

Excel Magic Trick 752: Fill Column With Categories Using Approximate Lookup Formula

Excel Magic Trick 756: Create Sequential Dates Across Sheets & Extract Sheet Name To Cell

Excel Magic Trick 756.5: Add Monday To Friday Sales Only From Totals On Many Sheets

Excel Magic Trick 757: Two Lookup Values & 2 Lookup Columns? Great Formula INDEX & MATCH

Excel Magic Trick 757.5: Two Lookup Columns Or Sum With Two Criteria?

Excel Magic Trick 758: Extract Data With Two Criteria - 5 Formula Methods

Excel Magic Trick 758.5: Extract Data With Four Criteria VLOOKUP & INDEX SUM, AND, OR Functions

Excel Magic Trick 759: Array Formula To Sort List & Remove Duplicates - Dynamic Named Range

Excel Magic Trick 760: OR AND AND Logical Test To Extract Data With Formula Or Advanced Filter

Excel Magic Trick 761: Formula Displaying Multiple Modes & Counting Modes Excel 2010 MODE.MULT

Excel Magic Trick 762: Two Way Lookup from Multiple Tables & Lookup Tables Sorted Descending

Excel Magic Trick 763: Formula to Sort Words (including Duplicates) and extract data

Excel Magic Trick 764: CHOOSE Function To "Mash" Columns Together To Create Lookup Tables

Excel Magic Trick 765: Formula To Sort Top 3, Including Ties

Excel Magic Trick 766: Count Times Before And After A Stated Time.

Excel Magic Trick 767: Count Months from Start and End Date

Excel Magic Trick 768: Gradebook Average w Criteria and Conditionally Format Less Than 4 Tests Taken

Excel Magic Trick 769: Adding & Conditional Formatting with NOT Criteria

Excel Magic Trick 770: Count Cells With Color Using Filter Feature or SUBTOTAL function

Excel Magic Trick 771: Calculate Your "Current" Grade: SUMIF, SUM & VLOOKUP functions

Excel Magic Trick 772: Remove Spaces From Number and Convert To Number

Excel Magic Trick 773: VLOOKUP to lookup last character in ID Code & Convert Number Text to Number

Excel Magic Trick 774: Dynamic Data Validation AND Dependent Data Validation Together

Excel Magic Trick 775: Round to 5 Minutes for Integer Values or Time Values ROUND & MROUND

Excel Magic Trick 777: SUMPRODUCT Function -- Basics To Advanced (14 Examples)

Excel Magic Trick 777.5: SUMPRODUCT Function OR Criteria, 2 Tips: TRUE+FALSE & TRUE+TRUE

Excel Magic Trick 778: INDEX & MATCH Lookup Functions Beginning To Advanced (18 Examples)

Excel Magic Trick 777.75: SUMPRODUCT Solves: SUMIF Won't Calculate From Closed Workbook

Excel Magic Trick 779: SUMIFS Faster Than SUMPRODUCT & TEXT When Using "Jan" Month Criteria

Excel Magic Trick 780: 3-D Cell References For SUMIF Function - Adding with Criteria Across Sheets

Excel Magic Trick 781: Three Way Lookup: INDEX and MATCH and Concatenated Ranges & Cells

Excel Magic Trick 782: Find All Numbers With 4, 2, 3 ISNUMBER & SEARCH functions