•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?
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]
Want to read more?
Check out the full article on the original site
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