# Operating with matrices without macros - help

#### Nunosoares86

##### New Member
Hi.

I have a [100, 500] matrix with information of energy consumption every 15 min during the day for nearly 2 years.
I would like to have for every month and for every week day (monday till Sunday) the average values of energy consumption, per each 15 min of the 24h.
Are there any chances of doing it without using macros - I don't know how to use them.

 FROM: TO: Wed Thu Fri Sat Sun Mon Tue Month JAN Date/E. Consump. 04-01-2012 05-01-2012 06-01-2012 07-01-2012 08-01-2012 09-01-2012 10-01-2012 ... Day/E. Consump. Mon Tue Wed Thu Fri Sat Sun 00:00 0,02 0,03 0,03 0,16 0,03 0,06 0,06 .. 00:00 average(total Monday - Jan) 00:15 0,01 0,01 0,04 0,14 0,05 0,05 0,05 .. 00:15 00:30 0,01 0,01 0,01 0,12 0,05 0,04 0,04 .. 00:30 00:45 0,02 0,02 0,01 0,17 0,03 0,05 0,05 .. 00:45 01:00 0,04 0,01 0,01 0,14 0,02 0,05 0,05 .. 01:00 01:15 0,03 0,02 0,02 0,18 0,01 0,05 0,05 .. 01:15 01:30 0,03 0,03 0,01 0,16 0,03 0,05 0,05 .. 01:30 01:45 0,03 0,04 0,02 0,12 0,03 0,05 0,05 .. 01:45 02:00 0,01 0,02 0,04 0,17 0,04 0,05 0,05 .. 02:00 02:15 0,01 0,01 0,04 0,10 0,03 0,04 0,04 .. 02:15 02:30 0,01 0,02 0,02 0,16 0,04 0,05 0,05 .. 02:30 02:45 0,02 0,02 0,01 0,15 0,02 0,04 0,04 .. 02:45 03:00 0,01 0,01 0,01 0,13 0,01 0,04 0,04 .. 03:00 03:15 0,02 0,02 0,02 0,18 0,01 0,05 0,05 .. 03:15 ... .. .. .. .. .. .. .. .. ...

<tbody>
</tbody>

Nuno

### Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Replies
4
Views
256
Replies
3
Views
243
Replies
9
Views
510
Replies
3
Views
261
Replies
48
Views
3K

1,221,064
Messages
6,157,705
Members
451,434
Latest member
VanDookie

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back