Pennsylvania Auditors Warned of Dead People, Duplicates on Voter Rolls

Pennsylvania auditors alerted officials of possible dead people and duplicate registrations on the state’s voter rolls last year, but the warnings went unacknowledged.

In December 2019, Pennsylvania’s Department of Auditor General (DAG) released the findings of an audit report conducted January 1, 2016 to April 16, 2019 but was limited in scope because of “a lack of cooperation and a failure to provide the necessary information by” Pennyslvania’s Department of State, the Department of Transportation, and four county election offices.

Due to the state’s noncooperation, the auditors were “unable to establish with any degree of reasonable assurance” that the state’s voter rolls system is “secure and that Pennsylvania voter registration records are complete, accurate, and in compliance with applicable laws, regulations, and related guidelines.”

Even without cooperation from state agencies and multiple county election offices, the report “identified tens of thousands of potential duplicate and inaccurate voter records, as well as voter records for nearly three thousand potentially deceased voters that had not been removed” from Pennsylvania voter rolls.

Specifically, the report analyzed the voter registration records for the state’s more than 8.5 million voters and alerted the Pennsylvania Secretary of State of “potential inaccuracies,” including:

  • 24,408 cases where a driver’s license number was listed in more than one voter record
  • 13,913 potential duplicate voter registrations
  • 6,876 potential date of birth inaccuracies
  • 2,230 potential date of birth and/or registration date inaccuracies
  • 2,991 records of potentially deceased voters

On the issue of dead people on Pennsylvania’s voter rolls, at least 2,094 of the 2,991 identified by auditors had their death notices sent to the Secretary of State’s office so the voter registration would be canceled.

Auditors stated that the manual process of canceling voter registrations for dead people “depends on the accuracy of the data” in the state’s voter rolls and thus if a “piece of personal information is inaccurately listed in the voter record,” the death notice may be dismissed and the deceased registrant could stay on the rolls.

The full report can be read here:

Pennsylvania Audit Report by John Binder

Since November 3, the Philadelphia Republican Party has alleged that dead people voted in the state of Pennsylvania. Likewise, an amended lawsuit filed by the Public Interest Legal Foundation claims that there are at least 21,000 dead people on Pennsylvania’s voter rolls that were not removed in time for the presidential election.

John Binder is a reporter for Breitbart News. Follow him on Twitter at @JxhnBinder.

Source link

How to Highlight Duplicates in Google Sheets and Remove

How to quickly highlight cells with duplicate values in Google Sheets using conditional formatting. The duplicate cells can be easily removed from the spreadsheet with Google Script.

The Email Extractor app pulls emails addresses of your contacts from Gmail into a Google Sheet. You can then use Mail Merge or Document Studio to send personalized emails to your contacts from within the sheet itself.

That said, the imported mailing list may sometimes have duplicate email addresses and it is thus be a good idea to clean up the data in your Google Sheet by removing duplicates before sending out the emails.

Highlight Duplicates in Google Sheets

You can use Conditional Formatting in Google Sheets combined with the COUNTIF formula to quickly highlight cells that contain duplicate values.

Here’s how you can find duplicates in Google Sheets:

  1. Open the Google Sheet containing your data and go to the Format menu.

  2. Select Conditional Formatting from the expanded menu. This will help us change the colors of cells, rows or columns that meet a specific criteria.

  3. In the Apply to Range input box, add the range of cells that contain possible duplicates. In our case, the email addresses are in column A so we can put A:A to specify the entire A column.

  4. Under the ‘Format cells if’ section, choose “Custom formula is” from the dropdown list as set the formula as =COUNTIF(A:A, A1) > 1

Click the Done button and you’ll instantly notice that all duplicate cells are highlighted as shows in the screenshot below.

Duplicate Cells in Google Spreadsheet

The COUNTIF Function

The COUNTIF function in Google sheets (and Microsoft Excel) essentially counts the number of cells in the range that meet a specific criteria. For instance =COUNTIF(A:A, "apple") will count the number of cells that contain the word apple.

It can accept wildcard characters too so =COUNTIF(A:A, "apple?") will count cells that contain the word apple or apples. Or say =COUNTIF(A:A, "*") and it will highlight all email address that end with a gmail address.

Please note that the COUNTIF function is case-insensitive so values like and are seen as duplicates.

Highlight Entire Row Containing Duplicates

If you’ve noticed in the previous screenshot, only specific cells that have duplicate values are highlighted through conditional formatting.

However, if you would like the Google Sheet to highlight the entire spreadsheet row that contains duplicate values, we need to slightly tweak the formatting rule.

  1. Go to the Apply to Range input box and specify the entire spreadsheet range, not just the column that contains duplicates.

  2. In the custom formula,use absolute reference for the range and also change criterion to use $A1 instead of A1 . When we use $A1 , we are telling Google Sheet to only change the row but lock the column.

The new duplicate detection formula reads =COUNTIF($A$1:$C$50, $A1)>1

Highlight Duplicate Rows in Spreadsheet

Compare Multiple Columns for Duplicates

If you would like to determine duplicates by comparing data in multiple columns of the Google Sheet, use COUNTIFS instead of COUNTIF .

For instance, if column A is Email Address and column B is Company Name and you would like highlight duplicates cell only when the combination of values in Column A and B is identical, the new formula can be written as =COUNTIFS(A:A, A1, B:B, B1)>1

Remove Duplicate Rows in Google Sheets

Now that we have figured out a simple method to highlight duplicates in Google Sheets, the next task is to remove all duplicate rows.

There are two ways to go about it – either use Google Apps script or use the built-in feature of Google Sheets to remove duplicates.

First, highlight the entire column in Google Sheet that contains the duplicate data. Next, go to the Data menu and choose the Remove Duplicates option.

Select which columns to include and whether or not the selected range has any header row. Click Remove duplicates and your list is clean up in one go. Like with COUNTIF function, Google Sheets will ignore case and formatting when determining duplicates.

Remove Duplicate Rows

Remove Duplicates with Google Scripts

If you prefer automation, here’s a little snippet that will remove the duplicates in your active Google Sheet based on data in the first column.

function removeDuplicateRows() {

Source link