Tag Archives: formula

Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

Duplicate Lookup or Lookup 1 value, return many for a column Part 2. Formula to return all the numbers from a column that contains text and numbers. See an array formula that uses the functions: COUNT, IF, ROWS, INDEX, ISNUMBER, … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , | 15 Comments

Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

Duplicate Lookup or Lookup 1 value, return many for a table Part 1. Return winning bets for week from a football betting database. See a formula that will return multiple items when there are two criteria for the data extraction. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , | 25 Comments

Excel Hlookup

Be sure to also check this great video on Vlookup: This video introduces and advances a very useful and practical example for the Hlookup function. Duration : 0:14:28 Technorati Tags: best, computer software, excel, formula, function, functions, HLOOKUP, Horizontal, horizontal … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , | Leave a comment

YouTubersLoveExcel#50: Macro & Form Button

See how to create a basic Macro and then assign the Macro to a Form button. See how to fix a formula with an error with the IFERROR, IF, and ISERROR functions. Duration : 0:9:8 Technorati Tags: button, College, Community, … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , , , | Leave a comment

Microsoft Office Excel Formula and the Function Library

This video will show you the new look and features of Excel 2007 so you can make the decision to upgrade from Office 2003 to 2007. To purchase Excel 2007 training CD, please visit our website: http://www.computerlearningpro.com Duration : 0:1:4 … Continue reading

Posted in Learn Excel Formulas | Tagged , , , | Leave a comment

Functions Formulas in Excel 10 – Formula Auditing – Find Out Which Cells are Used in Your Formulas

Visit http://www.TeachExcel.com for more, including Excel Consulting, Macros, and Tutorials. Excel video tutorial about formula auditing in Excel and finding out what formulas point to what cells in a worksheet. Specifically this tutorial talks about tracing precedents and dependents in … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , | 1 Comment

Excel Magic Trick #126: Macro: Advanced Filter Extract Text

See how to create a macro that will do an Advanced Filter Movie Title Extract for a Movie Database. See how to create the TRUE FALSE formula for advanced filter before creating a Macro and then adding the Macro to … Continue reading

Posted in Learn Excel Macros | Tagged , , , , , , , , , , , , , , , | 21 Comments

Excel Formulas solved for you

Unearth the potential of Excel: At http://www.excel-formulas.com.au you will find the solution to your Excel-Formula problem and much more. Call Jürgen on 1300 66 46 55 to chat about your Excel-issues and get a quote on solving them. Duration : … Continue reading

Posted in Learn Excel Formulas | Tagged , , | Leave a comment

Excel Magic Trick 783: Date Functions & Formulas (17 Examples)

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. DAY function 2. TEXT Function to get Day spelled out, like “Monday” 3. TEXT Function to get Month spelled out, like “January” 4. MONTH Function 5. YEAR function 6. Last Day in Month: EOMONTH function 7. … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 Comments

Excel Magic Trick 794: Conditional Formatting MAX or MIN or Top 3 Value/s In Row

Download file: https://people.highline.edu/mgirvin/ExcelIsFun.htm 1. Create Logical Formula for Conditional Formatting to highlight the lowest smallest value in the row using the MIN function and Mixed Cell References. 2. Create Logical Formula for Conditional Formatting to highlight the largest biggest value … Continue reading

Posted in Learn Excel Formulas | Tagged , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | 2 Comments