Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Importing CSV Finding Min/Max
I have multiple *.csv files that I want to find the min/max of each data
column and write to an excel worksheet. The original *.csv data from the file does not need to be written out to the worksheet, only the min/max values for each column. For example, here is some sample data for *.csv File #1. Example of first few lines of *.csv File1 %TIME,DATE_TIME,Data A,Data B,Data C,Data D 1202626798.174,"02/01/08 11:00:03 MST",4368,-2.29,33.6,9.216e-07 1202626803.174,"02/01/08 11:00:08 MST",4752,.51,44.2,9.216e-06 1202626808.174,"02/01/08 11:00:13 MST",3992,1.23,-40.6,8.07e-07 Ideally, it would look something like this in the Excel spreadsheet: File1 Data A Data B Data C Data D Min 3992 -2.29 -40.6 8.07e-07 Max 4752 1.23 44.2 9.216e-06 Again, subsequently would follow File 2, File 3, etc. All data could be written to the same worksheet. Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing etc. | Excel Worksheet Functions | |||
Importing | Excel Worksheet Functions | |||
Importing Alan Beban's code on Arrays; Importing a module or a project | Excel Worksheet Functions | |||
Importing | Excel Discussion (Misc queries) | |||
Importing and Finding Matching data | Excel Programming |