Card Tricks

Posts Tagged ‘Enter’

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