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!!