February 13, 2026•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Matching calendars with sales data

Our take

Are you struggling to connect your weekly sales data with promotional periods? By aligning client and item sales with discount weeks, you can unlock valuable insights into your sales performance. To achieve this, you can leverage your matching key of client and item names to identify whether a week qualifies as a discount week—defined by having more than four days of discounts. This approach not only simplifies your analysis but also allows you to pull essential discount values and codes seamlessly.

Hi all, first time posting here.

In one table, I have client, item, week start date, week end date, and then sales values for that week.

In another table, on a separate sheet, i have, for each client and item, a period during which we ran a sale on the items, as well as the discount value.

The end goal is to match the weekly sales data with whether or not there was a discount in that period, using the rule that if a week has more than 4 days on discount, it counts as discount week (yes or no) and then in a 2nd column pulls the discount value and discount code (individual identifiers)

Any ideas how to do this?

Since i have multiple items/clients, i made a key that matches in both sheets, with client | item name for each week to make the matching easier.

submitted by /u/OkScientist5370
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Matching Discount Rates with Weekly Period by itemhttps://preview.redd.it/91pmnrkjcgjg1.png?width=891&format=png&auto=webp&s=67d5c09350eb2ad174cda02f23be77c7a52d48b8 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. submitted by /u/OkScientist5370 [link] [comments]

Matching calendars with sales data

Related Articles