SQL Server 2017

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table #Dataset 
(
    ID int not null,
    LName varchar(50) null,
    Fname varchar(50) null,
    DateOfBirth varchar(50) null,
    StreetAddress varchar(50) null,
    Source varchar(50) null,
)

insert into #Dataset (ID, LName, Fname, DateOfBirth, StreetAddress, Source)
values
('1', 'John', 'Ganske', '37171', '  1223 Sunrise St', 'Company XYZ'),
('2', 'John', 'Ganske', '37171', '  1233 Sunrise St', 'Company XYZ'),
('3', 'Brent', 'Paine', '20723', '  5443 Fox Dr', Null),
('4', 'Brent', 'Paine', '20723', '  5443 Fox Dr', 'Company XYZ'),
('5', 'Adam', 'Smith', '22805', '  1254 Lake Ridge Ct', Null),
('6', 'Adam', 'Smith', '22805', '  1254 Lake Ridge Ct', Null),
('7', 'Adam', 'Smith', '22805', '  1254 Lake Ridge Ct', 'Company XYZ'),
('8', 'Timothy', 'Johnson', '36165', '  1278 Lee H-W', Null),
('9', 'Timothy', 'Johnson', '36165', '  1278 Lee H-W', Null),
('10', 'Judy', 'Wilson', '32579', '  5678 Dotties Dr', 'Company XYZ'),
('11', 'Peter', 'Pan', '37507', NULL, Null),
('12', 'Peter', 'Pan', '37507', NULL, 'Company XYZ');

--select * from #Dataset
WITH cte AS (
SELECT *, 
  ROW_NUMBER() OVER(PARTITION BY LName, Fname, DateOfBirth, StreetAddress ORDER BY ID DESC) rn,
  SUM(CASE WHEN Source = 'Company XYZ' THEN 1 ELSE 0 END) OVER(PARTITION BY LName, Fname, DateOfBirth, StreetAddress) AS cnt
FROM #Dataset
)
SELECT *
FROM cte 
WHERE rn > 1
  AND cnt > 0
ORDER BY ID

ID	LName	Fname	DateOfBirth	StreetAddress	Source	rn	cnt
3	Brent	Paine	20723	5443 Fox Dr	null	2	1
5	Adam	Smith	22805	1254 Lake Ridge Ct	null	3	1
6	Adam	Smith	22805	1254 Lake Ridge Ct	null	2	1
11	Peter	Pan	37507	null	null	2	1