oksadimiks
New Member
- Joined
- Nov 2, 2011
- Messages
- 1
I have a spread sheet set up that lists vectors. It shows the name for the start point and the stop point, then has a name for that vector. I want to be able to type a point in a field and then get the name of all vectors that contain that point. So I need to search the start collumn for multiple matches and the end collumn for multiple matches, and return the values from the name collumn. I'm actually using open office, so I don't know if array functions will work.
Here's a snippet of the spreadsheet collumns I'm talking about:
<table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="3"> <colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td align="LEFT" height="17" width="86">START</td> <td align="LEFT" width="86">STOP</td> <td align="LEFT" width="86">Name</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,0</td> <td align="LEFT">0,0==1,0</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,1</td> <td align="LEFT">0,0==1,1</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,2</td> <td align="LEFT">0,0==1,2</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,3</td> <td align="LEFT">0,0==1,3</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,4</td> <td align="LEFT">0,0==1,4</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">1,1</td> <td align="LEFT">1,0==1,1</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,9</td> <td align="LEFT">1,0==2,9</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,0</td> <td align="LEFT">1,0==2,0</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,1</td> <td align="LEFT">1,0==2,1</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">1,2</td> <td align="LEFT">1,1==1,2</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,1</td> <td align="LEFT">1,1==2,1</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,2</td> <td align="LEFT">1,1==2,2</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,3</td> <td align="LEFT">1,1==2,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">1,3</td> <td align="LEFT">1,2==1,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,3</td> <td align="LEFT">1,2==2,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,4</td> <td align="LEFT">1,2==2,4</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,5</td> <td align="LEFT">1,2==2,5</td> </tr> </tbody> </table>
For sake of example how would I get all vectors that contain point 1,2 displayed in the same collumn?
Here's a snippet of the spreadsheet collumns I'm talking about:
<table frame="VOID" rules="NONE" border="0" cellspacing="0" cols="3"> <colgroup><col width="86"><col width="86"><col width="86"></colgroup> <tbody> <tr> <td align="LEFT" height="17" width="86">START</td> <td align="LEFT" width="86">STOP</td> <td align="LEFT" width="86">Name</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,0</td> <td align="LEFT">0,0==1,0</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,1</td> <td align="LEFT">0,0==1,1</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,2</td> <td align="LEFT">0,0==1,2</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,3</td> <td align="LEFT">0,0==1,3</td> </tr> <tr> <td align="LEFT" height="17">0,0</td> <td align="LEFT">1,4</td> <td align="LEFT">0,0==1,4</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">1,1</td> <td align="LEFT">1,0==1,1</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,9</td> <td align="LEFT">1,0==2,9</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,0</td> <td align="LEFT">1,0==2,0</td> </tr> <tr> <td align="LEFT" height="17">1,0</td> <td align="LEFT">2,1</td> <td align="LEFT">1,0==2,1</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">1,2</td> <td align="LEFT">1,1==1,2</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,1</td> <td align="LEFT">1,1==2,1</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,2</td> <td align="LEFT">1,1==2,2</td> </tr> <tr> <td align="LEFT" height="17">1,1</td> <td align="LEFT">2,3</td> <td align="LEFT">1,1==2,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">1,3</td> <td align="LEFT">1,2==1,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,3</td> <td align="LEFT">1,2==2,3</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,4</td> <td align="LEFT">1,2==2,4</td> </tr> <tr> <td align="LEFT" height="17">1,2</td> <td align="LEFT">2,5</td> <td align="LEFT">1,2==2,5</td> </tr> </tbody> </table>
For sake of example how would I get all vectors that contain point 1,2 displayed in the same collumn?