Identify Duplicates

[durgaraop21]

How to check duplicate values in a column1, create new  adde column, if in case duplicate values present in the column1 display as well new added column 

[olgad]

HI, group by by column 1

expand All
and you will see the count. if greater than 1 than there is a duplicate

[durgaraop21]

With out grouping, Is there any alternativies to fing the duplicates ?like IF condition like this,,
ex: i have tried somthing in statically : if ([Column1] <> "null") then Table.RowCount(Table.SelectRows(#"Changed Type5", each ([Column1] = "XXXXX"))) else ""
but is there in any altenativies.....