←Back to Beyond Market Intelligence
•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

What is the proper way to reference data based on mixed dates?

Our take

When referencing data based on mixed dates in Excel, it’s essential to ensure accuracy and clarity, especially when dealing with multiple entries per date. To effectively manage this scenario, consider using functions like `SUMIFS` or `AVERAGEIFS`, which allow you to specify criteria that align with your date requirements. This approach not only streamlines your calculations but also enhances data integrity by accommodating human input variability. By adopting these methods, you can transform your data analysis process, making it more reliable and insightful.

I already have this operating, but I'm fairly new to excel and it feels like there's probably a better way to go about it than how I'm doing it currently. So what is the correct way to reference information based on a date when the dates I'm referencing aren't necessarily the same? Probably a simple question for all of you, and thank you in advance for your help.

Image 1

Image 2

Based on the data in image 1, the expected outcomes in image 2 would be:

A = 3200

B = 10100

C = 14000

D = 500

EDIT: Didn't specify (my fault), but because the input for odometers is done by humans, I can't 100% trust that the highest value is going to be the correct value. Additionally, while the example doesn't show this (again, my fault) any given vehicle may have more than one entry per date.

submitted by /u/Weird-Rich4823
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#generative AI for data analysis#natural language processing for spreadsheets#cloud-based spreadsheet applications#Excel compatibility#Excel alternatives#big data management in spreadsheets#conversational data analysis#rows.com#real-time data collaboration#intelligent data visualization#data visualization tools#enterprise data management#big data performance#data analysis tools#data cleaning solutions#excel#data reference#mixed dates#odometer