| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to collect data from every 60th row?
Have a spreadsheet with monthly weather data on different sheets. There are
about 48,000 rows (the data is collected automatically every minute). What sort of formula could you have to copy say one line for every hour (i.e. every 60th row) and than paste that data into a new row on a separate sheet?! Many thanks -- Why work on Wednesday and stuff up two good long weekends |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
| collect data from different worksheet | Excel Worksheet Functions | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
