title: VBA excel column matching
body: <p>I have an excel sheet with values like this:</p>
  <blockquote>
  <p>R1:A 1 0 1 1 0 1<br />
  R2:B 0 0 1 1 0 0<br />
  R3:C 1 0 1 1 0 1<br />
  R4:D 1 0 1 1 0 1<br />
  R5:E 0 0 1 1 0 0<br />
  R-row</p>
  <p>OUTPUT:<br />
  A,C,D(since they have matching columns)<br />
  B,E</p>
  </blockquote>
  <p>I need a VBA script that groups the columns based on matching values.I need to run this on a large set of data(say 417 columns) and n rows ,please be more generalised.
  Please help me out.Thanks in advance.</p>