•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Matching Discount Rates with Weekly Period by item
Hi all, re-making the post with more context and sample data.
The goal here is to match the discount rate, for that specific item, with the discount period across multiple sheets. The issue I'm running into is getting the accurate rates when there are discounts overlapping a period. The rule should be that, if a week has more than 4 days attributable to a specific discount period, that is the rate that should be output.
The struggle has been making a formula which matches based on both weekly period and item, and returns the required discount rate from that same row. The solution should be scalable to about 100k rows of hundreds of items/weeks, across multiple years.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#rows.com
#financial modeling with spreadsheets
#generative AI for data analysis
#natural language processing for spreadsheets
#AI formula generation techniques
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#google sheets
#row zero
#cloud-based spreadsheet applications
#real-time data collaboration
#intelligent data visualization
#discount rate
#weekly period
#item
#discount period
#overlapping discounts
#accurate rates