Thread: Matching data
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
mems555
 
Posts: n/a
Default Matching data

Here is an example of the sort of data

Load1, Displacement1a, Displacement1b, Load2, Displ2a, Displ2b
0.13, 0.0002, 0.0003, 0.04, 0.0001, 0.0008
0.18, 0.0009, 0.0009, 0.22, 0.0027, 0.0026
0.22, 0.0012, 0.0011, 0.31, 0.0039, 0.0033
0.23, 0.0014, 0.0012, 0.32, 0.0044, 0.0036
0.31, 0.0027, 0.0017, 0.33, 0.0044, 0.0036
ect

Is there a way of matching the loads, if they are the same. Ideally i would
want something like this-
0.13, 0.0002, 0.0003, 0.04, 0.0001, 0.0008
0.18, 0.0009, 0.0009,
0.22, 0.0012, 0.0011, 0.22, 0.0027, 0.0026
0.23, 0.0014, 0.0012,
0.31, 0.0027, 0.0017, 0.31, 0.0039, 0.0033
ect