View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jmsla...@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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