Written by Super User.

List Name and Division properties of users whose specific attribute is Not Null

Get-ADUser -Filter * -properties division | where division -ne $null | Format-List -Property Name, division