Thread: [Solved] Sorting
View Single Post
 
Old 02-16-2016, 04:38 PM
gilmourlead gilmourlead is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Feb 2016
Posts: 2
gilmourlead is on a distinguished road
Default Sorting

I have incomplete contact list of about 2,000.
I want to sort by first, all the complete contacts (phone, address, and email),
then my people who have 2 of the 3 contact types,
then by people who only have 1 contact type.

example
rows 1-50 have data in columns A-E (5 columns total)
rows 51-80 only have data in 4 of those 5 columns
rows 81-150 only have data in 3 of those 5 columns
etc.

Is there any way to do that?

Thank you!!
Reply With Quote