Posts Tagged ‘logic’
February 16th, 2010
See how to create Boolean Logic formulas for AND and OR. See Logical Truth Tables for AND and OR. See how to create Array Formulas in three different ways: Array with SUM & IF functions (must use Ctrl + Shift + Enter) Array with SUMPRODUCT function (DON'T have to use Ctrl + Shift + Enter) Array with SUM function (must use Ctrl + Shift + Enter)
Tags:
February 14th, 2010
See how to take badly setup data (not in database / table format) and summarize it by date and shipping name into table format report. See these tricks to fix bad data so we can Add with Two Criteria: 1.Advanced Filter Unique Records Only 2.Go To Special Blanks 3.Create Formula to add missing dates to a column of dates so that the Summary Formula will work 4.See how to enter multiple formulas with one keyboard shortcut (Ctrl + Enter) 5.SUMPRODUCT function to add with two criteria 6.Learn about TRUE FALSE Boolean Math Logic
October 20th, 2009
This is just a sample of some of the stuff I do on the streets and out in public. myspace.com twitter.com facebook.com