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!!
|