Mark the first Unique Record in a list with VBA
Hello :),
New challange in the world of Excel.
If somebody can help me out. Thx!
I've got a list with column A, B, C. In Column.D want to have an "1" when the combined fields "A&B&C" are the first unique in the list.
If in another row the same combination "A&B&C" occur then report in that row in Column.D a "0".
I know that there are some countifs/array formulas for it, but when having many rows it makes it very slow. A VBA is faster in this cases.
regards, Johan
|