I have a workbook that I am sorting data and putting into an interactive table and graph.
I am currently manually filtering data from a large table and manually adding total pieces per discrepancy type and manually entering into a smaller table to sort and filter that data into an interactive table and chart. Is there a way to apply the formula being used in the smaller table, to the large table of data?
The formula I am referring to is in cell N7.
I have attached a sample of my data. The larger table is from an analyzer (using slicers), I then copy and paste the cells I want into a different worksheet, so the info is no longer connected to the analyzer we use to filter out data.
Made some slight modifications to your file. See if it works for you. I don't believe you need the ranking columns and formulas. Use structured tables in order to ease referencing in functions like SUMIFS and TAKE.
Hello Riny,
Thank you. It works great. How did you get it to fill the table with totals being highest to lowest?
I did a copy and paste (Not real familiar with structured tables) to run the query for Machine numbers and the list is not highest to lowest.
When you create a structured table, Excel put the filter buttons in the header rows. You can use these to filter but also to sort columns.
I figured it out, about two minutes after I responded. This is working just how I wanted it to.
Thank you for your help!
Have a great day!
Hello Riny,
How would I write the SUMIFS formula to look at Machine number and Discrepancy type?
Look in T27 at my attempt to make this happen.
