Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Aligning Two Sets of Data That Share Only Some Values
Hello,
This problem is hard to explain without an example. I am using Excel 2003. I have two sets of data: Set 1: Time Value 10:18:06 1 10:18:10 3 10:18:14 5 Set 2: Time Value 10:18:04 1 10:18:05 2 10:18:06 3 10:18:07 2 10:18:08 3 10:18:09 4 10:18:10 5 10:18:11 1 10:18:12 3 10:18:13 6 10:18:14 3 As you can see, set 1 and 2 share only some "time" values. What I would like to do is align the "values" at shared "time" from set 1 next to set 2 so I can create a formula to work with those two shared values. Any ideas how to automate a task to take the two sets of data above and create the following result: Time Set 2 Value Set 1 Value 10:18:04 1 10:18:05 2 10:18:06 3 1 10:18:07 2 10:18:08 3 10:18:09 4 10:18:10 5 3 10:18:11 1 10:18:12 3 10:18:13 6 10:18:14 3 5 Thanks for the help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
aligning data | New Users to Excel | |||
Excel graph 3 sets of data. 2 sets as lines 1 as column? | Charts and Charting in Excel | |||
Compare two columns by aligning same-values and spacing out differences | Excel Worksheet Functions | |||
aligning data | Excel Programming | |||
Aligning decimal numers to the centre of the cell and aligning dec | Excel Discussion (Misc queries) |