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
<TBODY>
</TBODY>
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 |
<TBODY>
</TBODY>