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
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
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 best, computer software, excel, formula, function, functions, HLOOKUP, Horizontal, horizontal lookup, look, Lookup, Microsoft, Microsoft Excel, rdjalayer, Software Tutorial, tutorial, up, Vertical, vlookup
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
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
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 arrows, auditing, dependents, errors, excel, formula, Help, precedents, trace, troubleshooting, workbooks, worksheets
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
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
