Most valuable professional
  • Hot Topics

Excel Formula, vba, or logic to remove certain occurrences

All, I'm looking for a Formula, vba, or logic to remove certain occurrences of a pattern. To make life easier, please see the table below. I want A formula or logic to calculate the column D as shown below. The idea is to get as minimum of records that show x, zz, y, ww without repition. i.e. to be able to identify the records of (x,zz) and (y,ww). too hard??? Thank you A 6/25/2014 6/25/2014 6/25/2014 6/25/2014

This question generated 38 answers. To proceed to the answers, click here.

This thread is current as of June 25, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel