ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Simplyfying Data from a Sheet (https://www.excelbanter.com/excel-discussion-misc-queries/186226-simplyfying-data-sheet.html)

SU

Simplyfying Data from a Sheet
 
I have an excel spreadsheet with a huge number of datapoints on 10 sec
intervals. There are 12 sets of datapoints arranged in columns with the first
column being time. I would like to simplify and extract data points per hour.

Please suggest a solution. I am currently using Vlookup and would like to
know if there is a better solution. Many thanks.


All times are GMT +1. The time now is 08:51 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com