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

Mark the first Unique Record in a list with VBA
 

Hi Johan,

Am Fri, 28 Aug 2020 03:17:45 -0700 (PDT) schrieb :

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.

you don't need an array formula.

Try it in D1 with:
=--(COUNTIFS(A$1:A1,A1,B$1:B1,B1,C$1:C1,C1)=1)


Regards
Claus B.
--
Windows10
Office 2016

Mark the first Unique Record in a list with VBA
 

Thanks.
Works quick enough

regards, Johan