Hi all and thanks for any help given. Due to confidentiality I can't share exact details or images but I hope to explain well enough to get help. I have 50,000+ rows of data, new data every hour from multiple devices at multiple locations, and I need to find averages for the separate devices over separate days. I have location name in column A, device name in column B, and date/ time in column C, results in column D. An example of the time format would be; 9/7/2022 7:00:00 PM. My hope was to type a location into E2, a device name into F2, and a date, e.g. 9/7/2022, into G2 then have a formula in H2 search and average all D columns in rows that match all three of those. Is that possible or is there a better way of doing this?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Average if or better solution
- Thread starter Qozar
- Start date
arthurbr
Well-known Member
- Joined
- Dec 8, 2006
- Messages
- 2,719
- Office Version
- 365
- Platform
- Windows
Your could try a Pivot Table, depending on your layout.
If your date/time are real date/time ( right aligned in cell) and not text looking like date/time, you can group by dates as required.
If they are text, let us know, there are solutions
BTW you can always use the XL2BB - Excel Range to BBCode to post some mock data
If your date/time are real date/time ( right aligned in cell) and not text looking like date/time, you can group by dates as required.
If they are text, let us know, there are solutions
BTW you can always use the XL2BB - Excel Range to BBCode to post some mock data
Upvote
0
