Excel Q, cause I have no clue how it works

[jdc]

datbeme wrote:
1. Select the range of data, including the headers.
2. Insert > Table
3. "Create Table" dialog will appear confirming range, such as: =$A$1:$D$35
4. Make sure "My table has headers" is selected and click OK.
5. Click on the drop down arrow in the First or Last Name column and deselect "blanks"

That will filter them out.

If you want to delete them forever, you can do the opposite. In other words, deselect all the boxes, then select "blanks" only to see just those rows, and then you can manually delete them. Remove the filter and you'll have all the rows with first and last name.

thanks. There were 450 records, about 200 blanks.... so I did it manually, didn't take long. Client was hot for it.

Will save this for next time. =)