July 19, 2023
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.
Moderators
January 31, 2022
Moderators
January 31, 2022
1 Guest(s)