Summary statistics for text file

[yoshe]

Hello,
I would like to output summary stats like min, max, avg for field values after I read in a text file (I'm working in excel vba). I thought this would be simple, but I'm having trouble figuring it out - there don't seem to be any predefined functions for these procedures. Do the min and max values have to be calculated line by line comparing two adjacent values, or is there some simpler way? Thanks for any insight.

 

[PHV]

I'm working in excel
So, why not using worksheet functions ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[yoshe]

PHV, wouldn't I have to output my data to excel cells in order to do that? This is not an option since the files are too large.