•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Comparing registration numbers YoY
Our take
To effectively compare registration numbers year-over-year for your event, you can utilize Excel's VLOOKUP function alongside date criteria. By analyzing the number of registrations X days before the event in both 2025 and 2026, you can gain valuable insights into trends and improvements. Ensure both data sets include a registration date column to facilitate accurate comparisons. With the right formula, you can seamlessly track participation changes and make informed decisions for future events.
Using excel to track registration for an event. I’d like to be able to compare how many people have registered X days to event vs last year at X days to event.
Both files have a column for the date someone registered.
I’d like a formula that compares how many people have registered in 2026 vs this time 2025.
Thinking of a v-lookup but also have to factor in the date.
Any help would be greatly appreciated!!!
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Tagged with
#Excel alternatives for data analysis#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#AI formula generation techniques#real-time data collaboration#real-time collaboration#formula generator#registration#excel#registered#event#compare#years#formula#date#track#v-lookup