E
Eaglered
I got help yesterday with an issue that was similar and understood how to get
it to work but I forgot that we also have the date to consider and 30 days
worth of data in one table.
I have the following data on Sheet 2 . . . .
Day Hr Min
** ** 0 10 20 30 40 50
5/1/2005 0 9 5 1 6 5 8
5/1/2005 1 2 5 2 5 8 4
5/1/2005 2 6 3 7 8 7 4
5/1/2005 3 8 6 8 6 4 2
5/2/2005 0 6 8 5 4 2 8
5/2/2005 1 6 2 5 8 4 6
5/2/2005 2 8 3 8 9 7 4
5/2/2005 3 5 1 5 7 8 9
What I need on Sheet 1 is the following . . . .
Date Time NMOC
5/1/2005 0:00 9
5/1/2005 0:10 5
5/1/2005 0:20 1
5/1/2005 0:30 6
5/1/2005 0:40 5
5/1/2005 0:50 8
5/1/2005 1:00 2
5/1/2005 1:10 5
5/1/2005 1:20 2
5/1/2005 1:30 5
. . . .
5/2/2005 0:00 6
5/2/2005 0:10 8
5/2/2005 0:20 5
5/2/2005 0:30 4
5/2/2005 0:40 2
5/2/2005 0:50 8
5/2/2005 1:00 6
5/2/2005 1:10 2
5/2/2005 1:20 5
5/2/2005 1:30 8
.. . . .
Is this possible?
Any help would be greatly appreciated!!
it to work but I forgot that we also have the date to consider and 30 days
worth of data in one table.
I have the following data on Sheet 2 . . . .
Day Hr Min
** ** 0 10 20 30 40 50
5/1/2005 0 9 5 1 6 5 8
5/1/2005 1 2 5 2 5 8 4
5/1/2005 2 6 3 7 8 7 4
5/1/2005 3 8 6 8 6 4 2
5/2/2005 0 6 8 5 4 2 8
5/2/2005 1 6 2 5 8 4 6
5/2/2005 2 8 3 8 9 7 4
5/2/2005 3 5 1 5 7 8 9
What I need on Sheet 1 is the following . . . .
Date Time NMOC
5/1/2005 0:00 9
5/1/2005 0:10 5
5/1/2005 0:20 1
5/1/2005 0:30 6
5/1/2005 0:40 5
5/1/2005 0:50 8
5/1/2005 1:00 2
5/1/2005 1:10 5
5/1/2005 1:20 2
5/1/2005 1:30 5
. . . .
5/2/2005 0:00 6
5/2/2005 0:10 8
5/2/2005 0:20 5
5/2/2005 0:30 4
5/2/2005 0:40 2
5/2/2005 0:50 8
5/2/2005 1:00 6
5/2/2005 1:10 2
5/2/2005 1:20 5
5/2/2005 1:30 8
.. . . .
Is this possible?
Any help would be greatly appreciated!!