title: Comparing and finding identical entries in two particular columns of different Excel files
body: <p>I've got two files where there's a particular column I need to compare. On file1 has it on the fourth column. On file2 the needed column is on the third column. I need to find identical entries in these two files and their specified columns.</p>
  
  <p><strong>File 1</strong></p>
  
  <pre><code>1 name addons wanted_column amount host
  </code></pre>
  
  <p><strong>File 2</strong></p>
  
  <pre><code>1 name wanted_column 
  </code></pre>
  
  <p>I'm fine with Linux shell scripting, Python or anything on Windows as long it's freeware/free software.  </p>
  
  <p>Ok, I was asked, what I've tried. I copied the whole columns from file1 and file2 to text files. Then I tried this command:</p>
  
  <pre><code>diff --changed-group-format='' --unchanged-group-format='%=' file1.txt file2.txt &gt; output.txt
  </code></pre>
  
  <p>This did give me the output I wanted, but when I'm comparing the data taken randomly from the wanted_column between file1 and file2, I can't find the entry from output.txt. That means this command coulnd't find every identical entry, it only found some.</p>