| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting a subset of data from multi columns
Hello,
I have a data set containing times (sampled every 3 seconds) and body temperatures corresponding to the sample time. What I would like to do is somehow select every 6, 9 or 12 second time intervals and it's corresponding body temperature and move them to two new columns. I would do this manually but I have +21000 rows of data and 12 such data sheets. Is there a quicker way to do this? Any help would be appreciated. Thanks, Al |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing Multi-Columns of Data in Different Files | Excel Discussion (Misc queries) | |||
| Selecting a subset of items from a list | Excel Worksheet Functions | |||
| How do I seperate data in one column into multi columns | Excel Worksheet Functions | |||
| How to enter symbols for subset or element of a subset in Excel? | Excel Worksheet Functions | |||
| Possible to apply Autofilter to a subset of available columns? | Excel Discussion (Misc queries) | |||
Threaded Mode
