Excel Forum



Excel Magic Trick #507: Fix Bad Data So We Can Add With Two Criteria & Make Summary Report


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





Got a Question? Ask it Here in the Forum.