How can I remove Duplicates with Data across different columns?

[JOSHSKORN]

For context, I'm building a spreadsheet comprising of all Group Policies. I started with a list that I've already applied, but I've now combined it with a list of all available GPOs. I now have a spreadsheet with 7243 rows.

I have:

• Policy Name - C
• Scope: (Machine or User) - D
• Policy Path - E
• Registry Information - F
• Applies to
• A set of columns for each version of Windows or each version of an app that has a group policy setting. If a policy applied to a version of Windows or app, I place an 'X' in the column- These I want to keep. The duplicates of these all contain the same information as the items stated above. This goes from columns H through BX.

So basically, for all rows, if columns H through BX are not empty, remove the duplicate rows (Compare columns C through F Only) where the cells of this range (H:BX) ARE empty.

Is this possible? Do I need to use VBA? If so, I'd be a bit lost...granted I'm already lost.

 

[Drrellik]

Welcome to the board.

Please use XL2BB - Excel Range to BBCode to upload a portion of your sheet to help others, help you.

That being said If I understand your request.

Compare entire rows of data and look for those with duplicate data in cells C-F only if there is data in any cell from H-BX and remove the duplicate rows leaving only one row with the duplicate data.

Consider adding a new column (a helper column) by inserting a new column A and numbering all your data for sorting back later.
then use custom sort, column C, Column D, Column E... to align your rows and manually delete the duplicates.

Then resort data based on column A and delete it when done.

 

[JOSHSKORN]

I wasn't sure how to use the macro earlier but I'd figured it out. This is a representation of about 27 rows. I manually filtered everything, ended up with 15 rows. Basically, when there's a duplicate, I keep the record that contains data from H-BX. I need to check multiple columns to ensure of a duplicate record. I visually noticed the column with a registry value is the unique one.

I'm seeing a lot of codes in this post, hopefully this posts correctly.

Windows11andWindowsServer2019PolicySettings--22H2.xlsx
	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY
4	HKCU\Software\Policies\Microsoft\MMC\{18BA7139-D98B-43c2-94DA-2604E34E175D}!Restrict_Run	At least Windows 2000	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X																																					This policy setting permits or prohibits the use of this snap-in. If you enable this policy setting, the snap-in is permitted and can be added into the Microsoft Management Console or run from the command line as a standalone console. If you disable this policy setting, the snap-in is prohibited and cannot be added into the Microsoft Management Console or run from the command line as a standalone console. An error message is displayed stating that policy is prohibiting the use of this snap-in. If this policy setting is not configured, the setting of the "Restrict users to the explicitly permitted list of snap-ins" setting determines whether this snap-in is permitted or prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is enabled, users cannot use any snap-in except those explicitly permitted. To explicitly permit use of this snap-in, enable this policy setting. If this policy setting is not configured or disabled, this snap-in is prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is disabled or not configured, users can use any snap-in except those explicitly prohibited. To explicitly prohibit use of this snap-in, disable this policy setting. If this policy setting is not configured or enabled, the snap-in is permitted. When a snap-in is prohibited, it does not appear in the Add/Remove Snap-in window in MMC. Also, when a user opens a console file that includes a prohibited snap-in, the console file opens, but the prohibited snap-in does not appear.
5	HKCU\Software\Policies\Microsoft\MMC\{18BA7139-D98B-43c2-94DA-2604E34E175D}!Restrict_Run	At least Windows 2000																																																																						This policy setting permits or prohibits the use of this snap-in. If you enable this policy setting, the snap-in is permitted and can be added into the Microsoft Management Console or run from the command line as a standalone console. If you disable this policy setting, the snap-in is prohibited and cannot be added into the Microsoft Management Console or run from the command line as a standalone console. An error message is displayed stating that policy is prohibiting the use of this snap-in. If this policy setting is not configured, the setting of the "Restrict users to the explicitly permitted list of snap-ins" setting determines whether this snap-in is permitted or prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is enabled, users cannot use any snap-in except those explicitly permitted. To explicitly permit use of this snap-in, enable this policy setting. If this policy setting is not configured or disabled, this snap-in is prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is disabled or not configured, users can use any snap-in except those explicitly prohibited. To explicitly prohibit use of this snap-in, disable this policy setting. If this policy setting is not configured or enabled, the snap-in is permitted. When a snap-in is prohibited, it does not appear in the Add/Remove Snap-in window in MMC. Also, when a user opens a console file that includes a prohibited snap-in, the console file opens, but the prohibited snap-in does not appear.
6	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RasAllUserProperties	At least Windows 2000 Service Pack 1		X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X																																					Determines whether a user can view and change the properties of remote access connections that are available to all users of the computer. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. This setting determines whether the Properties menu item is enabled, and thus, whether the Remote Access Connection Properties dialog box is available to users. If you enable this setting, a Properties menu item appears when any user right-clicks the icon for a remote access connection. Also, when any user selects the connection, Properties appears on the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Properties menu items are disabled, and users (including administrators) cannot open the remote access connection properties dialog box. Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can change properties of all-user remote access connections. Note: This setting takes precedence over settings that manipulate the availability of features inside the Remote Access Connection Properties dialog box. If this setting is disabled, nothing within the properties dialog box for a remote access connection will be available to users. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
7	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RasAllUserProperties	At least Windows 2000 Service Pack 1																																																																						Determines whether a user can view and change the properties of remote access connections that are available to all users of the computer. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. This setting determines whether the Properties menu item is enabled, and thus, whether the Remote Access Connection Properties dialog box is available to users. If you enable this setting, a Properties menu item appears when any user right-clicks the icon for a remote access connection. Also, when any user selects the connection, Properties appears on the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Properties menu items are disabled, and users (including administrators) cannot open the remote access connection properties dialog box. Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can change properties of all-user remote access connections. Note: This setting takes precedence over settings that manipulate the availability of features inside the Remote Access Connection Properties dialog box. If this setting is disabled, nothing within the properties dialog box for a remote access connection will be available to users. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
8	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_DeleteAllUserConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether users can delete all user remote access connections. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, all users can delete shared remote access connections. In addition, if your file system is NTFS, users need to have Write access to Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk to delete a shared remote access connection. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), users (including administrators) cannot delete all-user remote access connections. (By default, users can still delete their private connections, but you can change the default by using the "Prohibit deletion of remote access connections" setting.) Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can delete all user remote access connections. Important: When enabled, the "Prohibit deletion of remote access connections" setting takes precedence over this setting. Users (including administrators) cannot delete any remote access connections, and this setting is ignored. Note: LAN connections are created and deleted automatically by the system when a LAN adapter is installed or removed. You cannot use the Network Connections folder to create or delete a LAN connection. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
9	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_DeleteAllUserConnection	Windows Server 2003, Windows XP, and Windows 2000 only																																																																						Determines whether users can delete all user remote access connections. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, all users can delete shared remote access connections. In addition, if your file system is NTFS, users need to have Write access to Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk to delete a shared remote access connection. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), users (including administrators) cannot delete all-user remote access connections. (By default, users can still delete their private connections, but you can change the default by using the "Prohibit deletion of remote access connections" setting.) Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can delete all user remote access connections. Important: When enabled, the "Prohibit deletion of remote access connections" setting takes precedence over this setting. Users (including administrators) cannot delete any remote access connections, and this setting is ignored. Note: LAN connections are created and deleted automatically by the system when a LAN adapter is installed or removed. You cannot use the Network Connections folder to create or delete a LAN connection. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
10	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_LanConnect	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether users can enable/disable LAN connections. If you enable this setting, the Enable and Disable options for LAN connections are available to users (including nonadministrators). Users can enable/disable a LAN connection by double-clicking the icon representing the connection, by right-clicking it, or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), double-clicking the icon has no effect, and the Enable and Disable menu items are disabled for all users (including administrators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can enable/disable LAN connections. Note: Administrators can still enable/disable LAN connections from Device Manager when this setting is disabled.
11	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_LanConnect	Windows Server 2003, Windows XP, and Windows 2000 only																																																																						Determines whether users can enable/disable LAN connections. If you enable this setting, the Enable and Disable options for LAN connections are available to users (including nonadministrators). Users can enable/disable a LAN connection by double-clicking the icon representing the connection, by right-clicking it, or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), double-clicking the icon has no effect, and the Enable and Disable menu items are disabled for all users (including administrators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can enable/disable LAN connections. Note: Administrators can still enable/disable LAN connections from Device Manager when this setting is disabled.
12	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameAllUserRasConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether nonadministrators can rename all-user remote access connections. To create an all-user connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, the Rename option is enabled for all-user remote access connections. Any user can rename all-user connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure the setting, only Administrators and Network Configuration Operators can rename all-user remote access connections. Note: This setting does not apply to Administrators Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either Enabled or Disabled), this setting does not apply. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
13	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameAllUserRasConnection	Windows Server 2003, Windows XP, and Windows 2000 only																																																																						Determines whether nonadministrators can rename all-user remote access connections. To create an all-user connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, the Rename option is enabled for all-user remote access connections. Any user can rename all-user connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure the setting, only Administrators and Network Configuration Operators can rename all-user remote access connections. Note: This setting does not apply to Administrators Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either Enabled or Disabled), this setting does not apply. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
14	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameLanConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether nonadministrators can rename a LAN connection. If you enable this setting, the Rename option is enabled for LAN connections. Nonadministrators can rename LAN connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure this setting, only Administrators and Network Configuration Operators can rename LAN connections Note: This setting does not apply to Administrators. Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either enabled or disabled), this setting does not apply.
15	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameLanConnection	Windows Server 2003, Windows XP, and Windows 2000 only																																																																						Determines whether nonadministrators can rename a LAN connection. If you enable this setting, the Rename option is enabled for LAN connections. Nonadministrators can rename LAN connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure this setting, only Administrators and Network Configuration Operators can rename LAN connections Note: This setting does not apply to Administrators. Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either enabled or disabled), this setting does not apply.
16	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameConnection	Microsoft Windows Server 2003, Windows XP, and Windows 2000 Service Pack 1 operating systems only		X				X																																	X																															Determines whether users can rename LAN or all user remote access connections. If you enable this setting, the Rename option is enabled for all users. Users can rename connections by clicking the icon representing a connection or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Rename option for LAN and all user remote access connections is disabled for all users (including Administrators and Network Configuration Operators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If this setting is not configured, only Administrators and Network Configuration Operators have the right to rename LAN or all user remote access connections. Note: When configured, this setting always takes precedence over the "Ability to rename LAN connections" and "Ability to rename all user remote access connections" settings. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to rename remote access connections.
17	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameConnection	Microsoft Windows Server 2003, Windows XP, and Windows 2000 Service Pack 1 operating systems only																																																																						Determines whether users can rename LAN or all user remote access connections. If you enable this setting, the Rename option is enabled for all users. Users can rename connections by clicking the icon representing a connection or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Rename option for LAN and all user remote access connections is disabled for all users (including Administrators and Network Configuration Operators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If this setting is not configured, only Administrators and Network Configuration Operators have the right to rename LAN or all user remote access connections. Note: When configured, this setting always takes precedence over the "Ability to rename LAN connections" and "Ability to rename all user remote access connections" settings. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to rename remote access connections.
18	HKLM\SOFTWARE\Policies\Microsoft\Windows\DeliveryOptimization!DOAbsoluteMaxCacheSize	At least Windows Server 2016, Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		Specifies the maximum size in GB of Delivery Optimization cache. This policy overrides the DOMaxCacheSize policy. The value 0 (zero) means "unlimited" cache; Delivery Optimization will clear the cache when the device runs low on disk space.
19	HKLM\SOFTWARE\Policies\Microsoft\Windows\DeliveryOptimization!DOAbsoluteMaxCacheSize	At least Windows Server 2016, Windows 10																																																																						Specifies the maximum size in GB of Delivery Optimization cache. This policy overrides the DOMaxCacheSize policy. The value 0 (zero) means "unlimited" cache; Delivery Optimization will clear the cache when the device runs low on disk space.
20	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7												X	X	X		X	X	X		X	X	X	X	X	X	X	X	X		X	X	X	X												X		X	X	X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
21	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7																																																																						This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
22	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7												X	X	X		X	X	X		X	X	X	X	X	X	X	X	X		X	X	X	X												X		X	X	X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
23	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7																																																																						This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
24	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
25	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																																																																						This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
26	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
27	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																																																																						This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
28	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\3!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone.
29	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Lockdown_Zones\3!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone.
30	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\1!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone.
Sheet2

 

[JOSHSKORN]

Here is the filtered version

Windows11andWindowsServer2019PolicySettings--22H2.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY
1	New in Windows 11	File name	Policy Setting Name	Scope	Policy Path	Registry Information		Supported On																																																																Help Text
2								Windows																																	Windows Server																			Microsoft Edge	Microsoft Search			Internet Explorer		Media Player			NetMeeting	Terminal Services	Windows Installer				Google Chome	Mozilla Firefox
3								2000	2000 (SP1)	2000 (SP2)	2000 (SP3)	Me	XP	XP Pro	XP Pro (SP1)	XP Pro (SP2)	Vista	Vista (SP1)	7	7 (SP1)	8	8 (Ent)	8.1	8.1 (U2)	RT	RT (8.1)	10	10 (1511)	10 (1607)	10 (1703)	10 (1708)	10 (1709)	10 (1803)	10 (1809)	10 (1903/19H1)	10 (1909)	10 (2106)	10 (v2004)	11	11 (22H2)	2000	2000 (SP1)	2000 (SP3)	2000 (SP4)	2000 (SP5)	2003	2003 (SP1)	2003 (SP2)	2003 (Ent.)	2003 (R2)	2008	2008 (R2)	2008 (R2 SP1)	2012	2012 (R2)	2016	2019	2019 (v2004)	2022		3.01	4.0		6 SP1	10	9	11		3.0		v2.0	v3.0	v4.0	v4.5
4		mmcsnapins.admx	.Net Framework Configuration	User	Windows Components\Microsoft Management Console\Restricted/Permitted snap-ins	HKCU\Software\Policies\Microsoft\MMC\{18BA7139-D98B-43c2-94DA-2604E34E175D}!Restrict_Run	At least Windows 2000	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X																																					This policy setting permits or prohibits the use of this snap-in. If you enable this policy setting, the snap-in is permitted and can be added into the Microsoft Management Console or run from the command line as a standalone console. If you disable this policy setting, the snap-in is prohibited and cannot be added into the Microsoft Management Console or run from the command line as a standalone console. An error message is displayed stating that policy is prohibiting the use of this snap-in. If this policy setting is not configured, the setting of the "Restrict users to the explicitly permitted list of snap-ins" setting determines whether this snap-in is permitted or prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is enabled, users cannot use any snap-in except those explicitly permitted. To explicitly permit use of this snap-in, enable this policy setting. If this policy setting is not configured or disabled, this snap-in is prohibited. -- If the policy setting "Restrict users to the explicitly permitted list of snap-ins" is disabled or not configured, users can use any snap-in except those explicitly prohibited. To explicitly prohibit use of this snap-in, disable this policy setting. If this policy setting is not configured or enabled, the snap-in is permitted. When a snap-in is prohibited, it does not appear in the Add/Remove Snap-in window in MMC. Also, when a user opens a console file that includes a prohibited snap-in, the console file opens, but the prohibited snap-in does not appear.
5		networkconnections.admx	Ability to change properties of an all user remote access connection	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RasAllUserProperties	At least Windows 2000 Service Pack 1		X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X	X																																					Determines whether a user can view and change the properties of remote access connections that are available to all users of the computer. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. This setting determines whether the Properties menu item is enabled, and thus, whether the Remote Access Connection Properties dialog box is available to users. If you enable this setting, a Properties menu item appears when any user right-clicks the icon for a remote access connection. Also, when any user selects the connection, Properties appears on the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Properties menu items are disabled, and users (including administrators) cannot open the remote access connection properties dialog box. Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can change properties of all-user remote access connections. Note: This setting takes precedence over settings that manipulate the availability of features inside the Remote Access Connection Properties dialog box. If this setting is disabled, nothing within the properties dialog box for a remote access connection will be available to users. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
6		networkconnections.admx	Ability to delete all user remote access connections	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_DeleteAllUserConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether users can delete all user remote access connections. To create an all-user remote access connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, all users can delete shared remote access connections. In addition, if your file system is NTFS, users need to have Write access to Documents and Settings\All Users\Application Data\Microsoft\Network\Connections\Pbk to delete a shared remote access connection. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), users (including administrators) cannot delete all-user remote access connections. (By default, users can still delete their private connections, but you can change the default by using the "Prohibit deletion of remote access connections" setting.) Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can delete all user remote access connections. Important: When enabled, the "Prohibit deletion of remote access connections" setting takes precedence over this setting. Users (including administrators) cannot delete any remote access connections, and this setting is ignored. Note: LAN connections are created and deleted automatically by the system when a LAN adapter is installed or removed. You cannot use the Network Connections folder to create or delete a LAN connection. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
7		networkconnections.admx	Ability to Enable/Disable a LAN connection	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_LanConnect	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether users can enable/disable LAN connections. If you enable this setting, the Enable and Disable options for LAN connections are available to users (including nonadministrators). Users can enable/disable a LAN connection by double-clicking the icon representing the connection, by right-clicking it, or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), double-clicking the icon has no effect, and the Enable and Disable menu items are disabled for all users (including administrators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If you do not configure this setting, only Administrators and Network Configuration Operators can enable/disable LAN connections. Note: Administrators can still enable/disable LAN connections from Device Manager when this setting is disabled.
8		networkconnections.admx	Ability to rename all user remote access connections	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameAllUserRasConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether nonadministrators can rename all-user remote access connections. To create an all-user connection, on the Connection Availability page in the New Connection Wizard, click the "For all users" option. If you enable this setting, the Rename option is enabled for all-user remote access connections. Any user can rename all-user connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure the setting, only Administrators and Network Configuration Operators can rename all-user remote access connections. Note: This setting does not apply to Administrators Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either Enabled or Disabled), this setting does not apply. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to bypass this setting.
9		networkconnections.admx	Ability to rename LAN connections	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameLanConnection	Windows Server 2003, Windows XP, and Windows 2000 only	X					X																																	X																															Determines whether nonadministrators can rename a LAN connection. If you enable this setting, the Rename option is enabled for LAN connections. Nonadministrators can rename LAN connections by clicking an icon representing the connection or by using the File menu. If you disable this setting, the Rename option is disabled for nonadministrators only. If you do not configure this setting, only Administrators and Network Configuration Operators can rename LAN connections Note: This setting does not apply to Administrators. Note: When the "Ability to rename LAN connections or remote access connections available to all users" setting is configured (set to either enabled or disabled), this setting does not apply.
10		networkconnections.admx	Ability to rename LAN connections or remote access connections available to all users	User	Network\Network Connections	HKCU\Software\Policies\Microsoft\Windows\Network Connections!NC_RenameConnection	Microsoft Windows Server 2003, Windows XP, and Windows 2000 Service Pack 1 operating systems only		X				X																																	X																															Determines whether users can rename LAN or all user remote access connections. If you enable this setting, the Rename option is enabled for all users. Users can rename connections by clicking the icon representing a connection or by using the File menu. If you disable this setting (and enable the "Enable Network Connections settings for Administrators" setting), the Rename option for LAN and all user remote access connections is disabled for all users (including Administrators and Network Configuration Operators). Important: If the "Enable Network Connections settings for Administrators" is disabled or not configured, this setting will not apply to administrators on post-Windows 2000 computers. If this setting is not configured, only Administrators and Network Configuration Operators have the right to rename LAN or all user remote access connections. Note: When configured, this setting always takes precedence over the "Ability to rename LAN connections" and "Ability to rename all user remote access connections" settings. Note: This setting does not prevent users from using other programs, such as Internet Explorer, to rename remote access connections.
11	1607	deliveryoptimization.admx	Absolute Max Cache Size (in GB)	Machine	Windows Components\Delivery Optimization	HKLM\SOFTWARE\Policies\Microsoft\Windows\DeliveryOptimization!DOAbsoluteMaxCacheSize	At least Windows Server 2016, Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		Specifies the maximum size in GB of Delivery Optimization cache. This policy overrides the DOMaxCacheSize policy. The value 0 (zero) means "unlimited" cache; Delivery Optimization will clear the cache when the device runs low on disk space.
12	1607	userexperiencevirtualization.admx	Access 2013 backup only	Machine	Windows Components\Microsoft User Experience Virtualization\Applications	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7												X	X	X		X	X	X		X	X	X	X	X	X	X	X	X		X	X	X	X												X		X	X	X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
13	1607	userexperiencevirtualization.admx	Access 2013 backup only	User	Windows Components\Microsoft User Experience Virtualization\Applications	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2013BackupWin64.Access	At least Windows Server 2008 R2 or Windows 7												X	X	X		X	X	X		X	X	X	X	X	X	X	X	X		X	X	X	X												X		X	X	X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2013. Microsoft Access 2013 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2013 settings. If you enable this policy setting, certain user settings of Microsoft Access 2013 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2013 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
14	1607	userexperiencevirtualization.admx	Access 2016 backup only	Machine	Windows Components\Microsoft User Experience Virtualization\Applications	HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKLM\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
15	1607	userexperiencevirtualization.admx	Access 2016 backup only	User	Windows Components\Microsoft User Experience Virtualization\Applications	HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin32.Access HKCU\Software\Policies\Microsoft\UEV\Agent\Configuration\Applications!MicrosoftOffice2016BackupWin64.Access	At least Windows Server 2016 or Windows 10																				X	X	X	X	X	X	X	X	X	X	X	X	X	X																X	X	X	X																		This policy setting configures the backup of certain user settings for Microsoft Access 2016. Microsoft Access 2016 has user settings that are backed up instead of synchronizing between computers. Use the policy setting to suppress the backup of specific Microsoft Access 2016 settings. If you enable this policy setting, certain user settings of Microsoft Access 2016 will continue to be backed up. If you disable this policy setting, certain user settings of Microsoft Access 2016 will not be backed up. If you do not configure this policy setting, any defined values will be deleted.
16		inetres.admx	Access data sources across domains	Machine	Windows Components\Internet Explorer\Internet Control Panel\Security Page\Internet Zone	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\3!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone.
17		inetres.admx	Access data sources across domains	Machine	Windows Components\Internet Explorer\Internet Control Panel\Security Page\Locked-Down Internet Zone	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Lockdown_Zones\3!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone.
18		inetres.admx	Access data sources across domains	Machine	Windows Components\Internet Explorer\Internet Control Panel\Security Page\Intranet Zone	HKLM\Software\Policies\Microsoft\Windows\CurrentVersion\Internet Settings\Zones\1!1406	At least Internet Explorer 6.0 in Windows XP with Service Pack 2 or Windows Server 2003 with Service Pack 1																																																																						This policy setting allows you to manage whether Internet Explorer can access data from another security zone using the Microsoft XML Parser (MSXML) or ActiveX Data Objects (ADO). If you enable this policy setting, users can load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you select Prompt in the drop-down box, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone. If you disable this policy setting, users cannot load a page in the zone that uses MSXML or ADO to access data from another site in the zone. If you do not configure this policy setting, users are queried to choose whether to allow a page to be loaded in the zone that uses MSXML or ADO to access data from another site in the zone.
Sheet2 (2)

 

[JOSHSKORN]

I'd like to change my question a bit. I think I can focus my condition a bit more.

Column F is a Registry Path, with property. This "should be" unique throughout the entire spreadsheet. I'm going to assume it is.

That said, I want to remove duplicate values of Column F. The criteria to keep a specific row would be if cells of a row H:BV are all blank. If these are all blank, I want this row removed.

Here's what I know. I found this code, which will remove banks. It looks like it looks for duplicate values in columns A and B, within range A1:C100.

ActiveSheet.Range("A1:C100").RemoveDuplicates Columns:=Array(1,2), Header:=xlYes

Applying it to my code, it's so far looking like this, granted I haven't tested this.

ActiveSheet.Range("A4:BY7244").RemoveDuplicates Columns:=Array(7), Header:=xlYes

Next trick, of the ones that get filtered, I want to keep those with contents from H through BY, and if I'm correct, that's Columns 8 through 77.

All in all, it looks like my logic will be similar to this:

1. Sort by Column F (I can record a Macro and get the code from it to do this)
2. Remove Duplicates entries with blanks in rows H-BY.

In columns H-BY, I'm looking for any entry. There could be one cell within a row of that range that has the letter 'X' placed in it, This is the row to keep. Duplicates, that is, rows with the same registry reference (Column F), all cells within this range will be blank, therefore removed.

Hopefully, I'm making sense.