I have a very large excel workbook that has a sheet off almost 600,000 lines, column B has duplicates. i have done a conditional format to highlight all unique and first occurrences.
i am trying to write a VB script that will go down every row and if the cell is colored that write a 1 in cell z for that row if it is not colored then write a 0 in cell z for the row.

or a program that will in one sweep find the unique & first occurrences and mark the cell with 1 or 0

ANY help is appreciated.