New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Sorting problem

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Sorting problem

Postby reddogracing » Fri Mar 18, 2016 9:33 am

Hello.

I have a typical contact sheet for our organization members name address etc. I have 5 special columns Officials, attended meeting 1, attended meeting 2, email , cell phone.

I want to sort this list of names alphabetical so that; ONE the officials are on top. and then only people who have attended meeting or have a cellphone or email.

Anyone who has blanks in any of the 5 columnes are listed alpha after the ones that do have data in at least one of the 5 columns
  • 0

reddogracing
Rookie
 
Posts: 1
Joined: Mar 18, 2016
Reputation: 0
Excel Version: 14.6.0 mac2011

Re: Sorting problem

Postby gebobs » Mon Mar 21, 2016 1:10 pm

reddogracing wrote:Anyone who has blanks in any of the 5 columnes are listed alpha after the ones that do have data in at least one of the 5 columns


This part doesn't jibe. To wit:

If Blanks >=0 List alphanumerically after Blanks < 5.

Did you mean to say: "Anyone who has blanks in all of the 5 columns..."?

If that's the case, a few helper columns will be needed.
Helper1 = IF(OR(Attend1,Attend2),TRUE,FALSE)
Helper2 = IF(COUNTBLANK(5columnsrange)>0,TRUE,FALSE)

FInally, sort by order of Name, Helper2, Helper1, Official.
  • 0

gebobs
Regular
 
Posts: 74
Joined: Feb 23, 2015
Reputation: 9
Excel Version: 2010


Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 42 guests