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 B C D
6/25 X ZZ 1
6/25 X WW 0
6/25 Y ZZ 0
6/25 Y WW 1


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