ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Matching data (https://www.excelbanter.com/excel-discussion-misc-queries/70011-matching-data.html)

mems555

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





mems555

Matching data
 
Is this not possible on excel then? Can anyone help me?


All times are GMT +1. The time now is 09:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com