nebrahimjee
New Member
- Joined
- Mar 6, 2014
- Messages
- 1
Hi. I have a temperature mapping system at work and every day i get exported to excel a spreadsheet that logs temperatures twice a minute.
By the end of a week i have several thousand rows that look like this:
<colgroup><col><col></colgroup><tbody>
</tbody>
And so on.... In column A is that Date/Time, and Column B has the temperatures. Now i need to work out the daily maximum and minimums.
At the moment I copy all one days logs into another spreadsheet then just sort by column B, and write down the top and bottom temperatures.
This sucks, and takes too long. I have 6 spreadsheets of data (different thermometers) and i have about 3months of data on each spreadsheet that now needs to be processed!
Any help would be greatly appreciated. I do not understand much about Visual Basic code, so hopefully i can get a real easy simple solution!
Thanks in advance!
By the end of a week i have several thousand rows that look like this:
08/01/2014 03:38 | 15.6 |
08/01/2014 03:38 | 15.5 |
08/01/2014 03:39 | 15.6 |
08/01/2014 03:39 | 15.5 |
08/01/2014 03:40 | 15.6 |
<colgroup><col><col></colgroup><tbody>
</tbody>
And so on.... In column A is that Date/Time, and Column B has the temperatures. Now i need to work out the daily maximum and minimums.
At the moment I copy all one days logs into another spreadsheet then just sort by column B, and write down the top and bottom temperatures.
This sucks, and takes too long. I have 6 spreadsheets of data (different thermometers) and i have about 3months of data on each spreadsheet that now needs to be processed!
Any help would be greatly appreciated. I do not understand much about Visual Basic code, so hopefully i can get a real easy simple solution!
Thanks in advance!