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!!

The easiest answer is to create a 'hybrid' key.. that is insert a column
before column A. it's value will be the concatenation of all the fields you
need (most people use a seperator between fields too... like a pipe | or
dashes ---)

"Eaglered" wrote:

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!!