Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Filter data set on hourly basis

0

I've an excel sheet that contains data every hour of the year. I'd like to filter the data to get the values from from 8 am to 4 pm for the weekdays only. Then I want to have the monthly total and average for the filtered data.

I'm using excel 360 on MAC OS.

excel
MS Office Version: 365
posted by: ahemaida on Tue Jan 18, 2022 at 12:46 pm
Answer
Discuss

Discussion

Hi and welcome to the Forum.

Please edit your question and use the Add Files... button to upload a representative Excel file (not any personal data) to show how the hourly data is stored. It should be easy to filter and delete the unwanted data.

Also, kindly update your Forum profile to show which version of Excel you use- it may rule out some solutions.
John_Ru (rep: 6142) Jan 18, '22 at 1:37 pm
Did you solve it (without uploading a file) then?
John_Ru (rep: 6142) Jan 20, '22 at 6:35 am
Thank you so much. I solved it already.
The way I solved wasn't helpful to get the monthly total and average.
ahemaida Jan 20, '22 at 10:54 pm
Fair enough but please update your profile anyway (for your next question) 
John_Ru (rep: 6142) Jan 30, '22 at 5:47 pm
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login