Grouping a Series Of Rows

  • Thread starter Thread starter Pivotrend
  • Start date Start date
P

Pivotrend

hello

i have a series of raws that have information on them that i need t
group in a time period

so much information the sheet is tOoO BiG

k
ie; i have a column that display date
a column that display time in seconds
& other columns with numbers on them (Prices)

1st row says
A1:03/04/2004 ,B1:09:15:01 AM ,C1:0.78 ,D1:0.78 ,E1:0.79

2nd row says
A1:03/04/2004 ,B1:09:15:31 AM ,C1:0.78 ,D1:0.77 ,E1:0.78

i need to Group all information in one minute, say between 09:15:00 A
& 09:15:59 AM

then this will start Over to Group information in all rows for the nex
minute 09:16:00 AM to 09:16:59 AM

is that possible
 
Your could do this with a sort. Highlight
Column's 'A', 'B', 'C', 'D' and 'E'. Then sort by 'B'

Charlie O'Neill
 
You can do that with a macro. Record the sort steps in
a 'record new macro' and add the marco to a button that
can be selected after the data is entered.

Charlie O'Neill
 
Back
Top