Sorting based on input

[abhi234u]

Hi there,

I have a below challenge in front of me. When ever the user inputs a value from source, that value should be first in the destination and the rest of source values should be sorted as below. Any inputs please. Below are examples

<table>
<thead>
<tr>
<th class="Source-cell">Source</th>
<th class="Input Cell-cell">Input Cell</th>
<th class="Output-cell">Output</th>
</tr>
</thead>
<tbody>
<tr class="firstRow">
<td class="Source-cell">abc</td>
<td class="Input Cell-cell">abc</td>
<td class="Output-cell">abc</td>
</tr>
<tr>
<td class="Source-cell">xyz</td>
<td class="Input Cell-cell"></td>
<td class="Output-cell">efg</td>
</tr>
<tr class="lastRow">
<td class="Source-cell">efg</td>
<td class="Input Cell-cell"></td>
<td class="Output-cell">xyz</td>
</tr>
</tbody>
</table>




<table>
<thead>
<tr>
<th class="Source-cell">Source</th>
<th class="Input Cell-cell">Input Cell</th>
<th class="Output-cell">Output</th>
</tr>
</thead>
<tbody>
<tr class="firstRow">
<td class="Source-cell">abc</td>
<td class="Input Cell-cell">xyz</td>
<td class="Output-cell">xyz</td>
</tr>
<tr>
<td class="Source-cell">xyz</td>
<td class="Input Cell-cell"></td>
<td class="Output-cell">abc</td>
</tr>
<tr class="lastRow">
<td class="Source-cell">efg</td>
<td class="Input Cell-cell"></td>
<td class="Output-cell">efg</td>
</tr>
</tbody>
</table>

 

[oldbrewer]

selection

abc

Source

abc

abc

abc below is M20

xyz

efg

<<<<<

efg

xyz

#####

abc

efg

xyz

efg

abc

xyz

xyz

abc

formula in cell marked <<<<<

efg

=OFFSET($M$19,MATCH($F$17,$M$20:$M$25,0),1)

formula in cell marked #####

=OFFSET($M$19,MATCH($F$17,$M$20:$M$25,0)+1,1)

<colgroup><col width="64" span="13" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[abhi234u]

Thanks Oldbrewer. What is in M19 and F17?

Thanks

 

[abhi234u]

Here is my cells for source and destination

<table>
<thead>
<tr>
<th class="Cell-cell">Cell</th>
<th class="Source-cell">Source</th>
<th class="Input Cell-cell">Input Cell</th>
<th class="Desired Output-cell">Desired Output</th>
<th class="Cell-cell">Cell</th>
</tr>
</thead>
<tbody>
<tr class="firstRow">
<td class="Cell-cell">E2</td>
<td class="Source-cell">abc</td>
<td class="Input Cell-cell">xyz</td>
<td class="Desired Output-cell">xyz</td>
<td class="Cell-cell">G2</td>
</tr>
<tr>
<td class="Cell-cell">E3</td>
<td class="Source-cell">xyz</td>
<td class="Input Cell-cell">Cell F2</td>
<td class="Desired Output-cell">abc</td>
<td class="Cell-cell">G3</td>
</tr>
<tr class="lastRow">
<td class="Cell-cell">E4</td>
<td class="Source-cell">efg</td>
<td class="Input Cell-cell"></td>
<td class="Desired Output-cell">efg</td>
<td class="Cell-cell">G4</td>
</tr>
</tbody>
</table>

 

[oldbrewer]

M19 is an empty cell used as the starting point in the offset formula

F17 is the abc that the user has selected

 

[abhi234u]

Below is what i am getting after i apply the formula

abc
0 <<<<< =OFFSET($F$6,MATCH($F$2,$E$2:$E$4,0),1)
0 #### =OFFSET($F$6,MATCH($F$2,$E$2:$E$4,0)+1,1)


Thanks