I have datasheet consist of four column. Time(in sec), time(hour), value and date (see attached file). in each hour there are 240-260 data point. i want to average only the last 30 cell for that particular hour for that particular day for the whole dataset. the last 30 cells are highlighted.

Can i do it with pivot table or macro or anything in excel.

Please help me out!!

More Arindam Roy's questions See All
Similar questions and discussions