I watched this video to count duplicates.
and if used the formula below.
However I want to take it a step further if you can please help...
Instead of outputting "1" if the cell is unique and "0" if it's not I want to create a unique id for each group of duplicate rows.
i.e. If row A1 and A6 I want the output to be the same "unique" number. So can group duplicate rows together.
Hope this makes sense.