Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sorting in Excel with Group Headers if the Exist

Posted on 2016-09-10
2
Medium Priority
?
120 Views
Last Modified: 2016-10-03
I have a table in Excel that contains some directory information - Name, Department, Extension, etc.

On another worksheet  within the same workbook, I want to created a filtered view of the directory. I only want to display a few of the fields, and I want them to be sorted by the person's last name. That part I can handle.

Here's the trick, I want a header row for each letter of the alphabet (but only if last names exist beginning with that letter), followed by the alphabetical list of names that begin with that letter.

So, instead of:

Appleby
Antler
Bates
Bogus
Dreyfus
Goony

I would get:

A
Appleby
Antler

B
Bates
Bogus

D
Dreyfus

G
Goony

(Nothing that "C", "E", "F" do not appear since there are no last names beginning with those records.)

I'm not sure if this is even possible, but I'm hoping it is!

Thanks!!
0
Comment
Question by:GMC02108
2 Comments
 
LVL 34

Expert Comment

by:Subodh Tiwari (Neeraj)
ID: 41792743
It would help all of us if you can upload a sample workbook and mock up the desired output manually to show all the steps you want to automate to get the desired output.
0
 
LVL 34

Accepted Solution

by:
Rob Henson earned 2000 total points
ID: 41793932
You could get something similar with a Pivot Table.

See attached.
Directory.xlsx
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
No other job is as rewarding and demanding as building an iPhone app is. It is not really in the hands of the developer for the success of an iPhone app. Many factors operate jointly for every iOS application's success in the market.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
Progress

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question