hi all
I'm locking for an excel VBA that would blank out cells in Col D (NOT delete entire row) when duplicate data is found but the trick is that it needs to be based on when there is a change of data in column C for ex.
So my goal here is to just have the first instances show 123 and the rest blank ETC..
thanks
I'm locking for an excel VBA that would blank out cells in Col D (NOT delete entire row) when duplicate data is found but the trick is that it needs to be based on when there is a change of data in column C for ex.
Column C | Column D |
ABC | 123 |
ABC | 123 |
ABC | 123 |
DEF | 456 |
DEF | 456 |
So my goal here is to just have the first instances show 123 and the rest blank ETC..
thanks