Also a question of my own, Why PowerShell and not just a formula? : =IF(COUNTIF($A$1:A2,A2)=1,COUNTIF(A:A,A2),"")
Used a formula, thank you for the assistance.