Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Matching data
Is this not possible on excel then? Can anyone help me?
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting #N/A from Vlookup when matching value exist in the lookup data range. | Excel Worksheet Functions | |||
Matching data using date criteria... | Excel Worksheet Functions | |||
Only text values matching using index/match lookup - data type pro | Excel Worksheet Functions | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Matching data in one column to another | Excel Worksheet Functions |