Extracting Specific Data from the same date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of minutely gathered data from various dates, I need to find
the max and min for each day and relocate it to a max and min table which
gives the max and the min of the day and the exact time that they occured. I
have about 50,000 data points, can anyone help?
 
Cleve,

Not sure why you would want to "relocate it to a ... table". This is what
queries are for. You don't indicate the Max or Min of what, so I'll assume
you want to know the maximum and minimum value in some field, for each day.

Your query would look something like this.

SELECT DATEVALUE(ObsDate), MAX(YourField) as MaxVal, Min(YourField) as MinVal
FROM YourTable
GROUP BY DATEVALUE(ObsDate)

HTH
Dale
 
The data I have are tics for the stock market for every minute of every day.
I need to find the high and the low for each day. Right now I have one
column for the date, and it is arranged vertically. I need excel to look at
each individual day as a vertical group find the max and the min of that day,
and keep the assiciated time. Right now I am filtering the data thought
AUTOFILTER and sorting each individual day by the stock price. On one end is
the max, on the other the min, but it takes forever.
 
Back
Top