title: Excel: Pair things up between two columns (A and B), and show unpaired values in columns C and D
body: <p>Excel buffs:</p>
  
  <p>There are many results showing up when searching for comparisons between two columns (ie: using VLOOKUP) but none of the results I have looked so far seems to do what I need in this particular way:</p>
  
  <p>Column A has following values: Z, Q, V, V, T, T</p>
  
  <p>Column B has following values: V, T, T, M</p>
  
  <p>Column C will display Z, Q, V (here we have one V because one set of 'V' pairs up, leaving us with one unpaired 'V')</p>
  
  <p>Column D will display M</p>
  
  <p>The other examples I've seen so far assumes Column C will not have 'V' in it because it's already found in Column A, regardless of how many times it showed up. </p>
  
  <p>Basically, instead, I need values between two columns paired up and removed, but leave me with any "odd ones" out. </p>
  
  <p>I've been unable to figure this one out using formulae - I've resorted to sorting everything first, then shifting cells in either Column A or B downwards until Columna A and B either have matching values or odd one out in each row</p>
  
  <p>Thanks in advance</p>
  
  <p>Edit: Another way of saying it: I'd like to "eliminate" paired up values from Columns A and B, until all pairs have been removed, leaving me with remaining values in Column A and B</p>