•2 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to return value from one row above when filtered? Building dynamic filtered pareto
Is there a way to return the value from one row above when filtered? To add context, I am trying to build an 80/20 Pareto chart utilizing a sort of balance sheet formula in column B where cell B5, as the first row of data, returns a copy of the cell contents in C5. However, I need to be able to filter to different sales reps in col E while maintaining the unique formulas in B5 vs B6. In other words, the first row of data changes when the filter on column E is activated.
| Col A | Col B | Col C | Col D | Col E | Col F sorted desc |
|---|---|---|---|---|---|
| Row 1 | 80/20 Pareto | Subtotal: | 100 | ||
| Row 4 | Customer | Sales Rep | Value | ||
| Row 5 | =C5 | =25/100 | XYZ Customer | Sales Rep A | 75 |
| Row 6 | =B5+C6 | =75/100 | 123 Customer | Sales Rep A | 25 |
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#Excel alternatives for data analysis
#big data management in spreadsheets
#generative AI for data analysis
#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
#rows.com
#AI formula generation techniques
#Excel compatibility
#formula generator
#Excel alternatives
#Pareto chart
#row above
#filtered