Posts Tagged ‘Go’
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
this is not me and these magic tricks needs a lot of practice, so you can do it perfectly and they can not see where the coin went. All you need is simple a coin. it is better if the coin is not too small or too big.