I need to indicate in the rows of column C where the the first duplicate value of Column A is when Column B is not blank. Any ideas?
See below example
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>
See below example
Column A | Column B | Column C |
12345 | abc | X |
12345 | abc | |
12345 | abc | |
12345 | abc | |
6789 | ||
6789 | ||
6789 | abc | x |
12347 | abc | x |
88888 | ||
88888 | ||
88888 | abc | x |
88888 | abc | |
88888 | abc | |
88888 | abc |
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>