•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to make that a cell in a new table only shows a filter result of another table?
Our take
Creating a summary table that reflects filtered results from another table is a common need in data management. With Microsoft 365 for Business, you can achieve this by leveraging dynamic array functions like `FILTER` or using `SUBTOTAL` in conjunction with criteria from your original table. This allows you to summarize filtered data effectively. If you’ve struggled with traditional methods, exploring these functions can simplify your workflow and enhance your data insights, making your analysis more impactful and efficient.
I have an entire table with all the data that I need and it already has filters, a total row and a couple of slicers. What I want to do next is to make a summary of the data after I filter it, basically a new table but it only shows the total amount of data after applying filters. I already tried using the subtotal function in the new table while referencing the original table with filters on it and also the row function. Any idea of how to do this or if is actually possible to do it?
edit: i have microsoft 365 for business version 2602
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- How to filter data on different sheets simultaneously?I'm looking for a solution to the following problem i'm facing: I have an XLS file with a bunch of sheets containing data inside. Each sheet contains a table with data. The data in each table is used to calculate values in a seperate overview sheet within the same file. Now, here is my question. Each of the tables in the sheets contains a column with an identifier and i would like to use this column to filter the data in the tables in all sheets simultaneuosly and have the data in the overview sheet re-calculated based on the applied filter. Example: Each table in each data sheet contains rows that have the identifier "A", but there are also rows of data with different identifiers. The data in the overview sheet uses all rows of data as a calculation basis. I want to apply a filter for identifier "A" through every table and have the overview sheet show calculated values for the filitered data only. I tried searching for solutions, but haven't found anything feasible so far. Hope, you understood my problem and maybe someone knows an elegant solution. If needed, i can provide a sample set of data in the structure i've described. Thanks a lot in advance! submitted by /u/henrikgreger [link] [comments]
- Can a User click on a cell in one worksheet and be taken to another that is filtered?Good day. I am not too advanced with Excel. I haven't used Macros or VBA but when googling my question, it suggested that may be the solution and when I tried, I couldn't figure it out. I have 3 worksheets: Data Pivot: to sum the data and provide a VLOOKUP for Main Main: a place for me to combine multiple Data worksheets My goal is that when a User clicks on a cell in the Main worksheet, they are taken to the Data worksheet AND it is filtered based on criteria, in this case "Store Name". I attached an image with the results I am hoping to achieve. https://imgur.com/a/FKus2xB Also, is there a way to skip the Pivot and have Main be able to SUM directly from Data? Thank you for any help! submitted by /u/IronNo5182 [link] [comments]
- Assistance with advanced filter optionsI have a report that is being generated through some janky software, and unfortunately the way I am getting the excel document can't be changed. This is a very basic example of what the sheet looks like, the actual generated report is thousands of rows: https://imgur.com/a/d0jNtNx For example, I want to filter for Bob's name in column A and also see all of Bob's associated comments in column B. If I apply a filter for Bob in column A, it hides everything in column B that are the relevant comments (obviously). To clarify, I want a filter to make it look like this: https://imgur.com/a/pgVJsLm And not like this: https://imgur.com/a/wCev8uH Perhaps the filter function isn't the right approach, so I am open to alternatives. submitted by /u/drspudbear [link] [comments]
- Using the #spill error as the resultI'm trying to use the filter function to generate some tables Now my one table has multiple rows that correlate to just one row in the Table I want to generate. If there is only one row that fulfills the criteria, I want the result to be one thing, and if I get a #spill error I would like it to say another thing (but not #spill). Is there any way to do this? Is there an easier way to do it? There is a column in the original data that contains the answer I want, but since it's in multiple rows I can't figure out how to not get the #spill result. I can't share any data as it is for work and English is not my native language so I'm sorry if I didn't explain properly. submitted by /u/gaensefuesschen [link] [comments]
Tagged with
#Excel alternatives for data analysis#generative AI for data analysis#big data management in spreadsheets#conversational data analysis#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#row zero#financial modeling with spreadsheets#rows.com#natural language processing for spreadsheets#Excel compatibility#business intelligence tools#Excel alternatives#filter#table