Filtering for duplicates in large data set, having crashing issues

[Excelnoob97]

I’m trying to remove the unique values from a large data set so im just left with the duplicates. I’ve tried filtering by color but it crashes excel every time. I’ve tried several things but none of them have worked. If anyone could offer some help I’d greatly appreciate it. The file has over 300000 rows that have to be checked for duplicates and filtered.

 

[sandy666]

maybe try Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Duplicates = let columnNames = {"raw"}, addCount = Table.Group(Source, columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(Source, columnNames, removeCount, columnNames, JoinKind.Inner)
in
    Duplicates

it will remove unique and you will stay with duplicates only

post an example of your data with real structure

 

[Excelnoob97]

maybe try Power Query

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    Duplicates = let columnNames = {"raw"}, addCount = Table.Group(Source, columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(Source, columnNames, removeCount, columnNames, JoinKind.Inner)
in
    Duplicates

it will remove unique and you will stay with duplicates only

post an example of your data with real structure

First Name	Middle Name	Last Name	Company Name	Street 1	Street 2
				7092 Hwy 6 N
				7092 Hwy 6 N
				50 Town and Country Blvd #710
				2000 Willowbrook D
				50 Town and Country Blvd #710

 

[Excelnoob97]

Its something like that but i only need to find duplicates within the Street 1/Address column.

 

[sandy666]

First Name	Middle Name	Last Name	Company Name	Street 1	Street 2
				7092 Hwy 6 N
				7092 Hwy 6 N
				50 Town and Country Blvd #710
				2000 Willowbrook D
				50 Town and Country Blvd #710
				Street 1
				7092 Hwy 6 N
				7092 Hwy 6 N
				50 Town and Country Blvd #710
				50 Town and Country Blvd #710

let
    Source = Excel.CurrentWorkbook(){[Name="Table5"]}[Content],
    Duplicates = let columnNames = {"Street 1"}, addCount = Table.Group(Source, columnNames, {{"Count", Table.RowCount, type number}}), selectDuplicates = Table.SelectRows(addCount, each [Count] > 1), removeCount = Table.RemoveColumns(selectDuplicates, "Count") in Table.Join(Source, columnNames, removeCount, columnNames, JoinKind.Inner),
    TSC = Table.SelectColumns(Duplicates,{"Street 1"})
in
    TSC