Explore BrainMass
Share

Explore BrainMass

    Excel Data Extraction

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    b. Filter the list and start the results in cell H6. You are to display sales which were greater than fifty-five units and whose per-unit price was no larger than $3.15 during 2005. Display in the body of the table the total sales for each salesperson.
    c. Filter the list and copy to v2 to display those 2012 return were greater than the 2011 return and less than the 2013 return or in the top 20 % of 2014 returns.

    © BrainMass Inc. brainmass.com October 10, 2019, 8:23 am ad1c9bdddf
    https://brainmass.com/computer-science/files/excel-data-extraction-623096

    Attachments

    Solution Preview

    Dear Student,
    Please find the solutions attached.
    b. Solution is POST623096_Problem3_Solution.xlsx
    By using the Filter feature, Data based on the criteria was selected.
    Solution: POST623096_Problem3_Solution.xlsx

    To Sub-total based on ...

    Solution Summary

    The excel filtering feature and sub-totalling is demonstrated using three examples.

    First solution shows, filtering a data list and to display sales which were greater than fifty-five units and whose per-unit price was no larger than $3.15 during 2005. Second slution displays the total sales for each salesperson.

    Third soltuon shows the filtering the list to display those 2012 return were greater than the 2011 return and less than the 2013 return or in the top 20 % of 2014 returns.

    $2.19