J vd Heuvel
New Member
- Joined
- Feb 4, 2015
- Messages
- 1
Hi all,
I'm working on a macro, which looks up a date in an excelsheet with up to 30000 rows. Each row contains date values (column C) and temperature values (column E). I have about 250 rows per day and I would like to return the minimum, maximum and average temperature for each day.
I tried to make a macro, in which I used the advanced filter function of excel, but too many calculations were needed and too much time. To improve I would like to use arrays instead, but I'm not experienced with that. I hope someone could help me with that. Thanks !
I would like to add a picture, but could only insert an URL, unfortunately
Kind regards,
Joran van den Heuvel
I'm working on a macro, which looks up a date in an excelsheet with up to 30000 rows. Each row contains date values (column C) and temperature values (column E). I have about 250 rows per day and I would like to return the minimum, maximum and average temperature for each day.
I tried to make a macro, in which I used the advanced filter function of excel, but too many calculations were needed and too much time. To improve I would like to use arrays instead, but I'm not experienced with that. I hope someone could help me with that. Thanks !
I would like to add a picture, but could only insert an URL, unfortunately
Kind regards,
Joran van den Heuvel
