Sorting in Excel with Group Headers if the Exist
Posted on 2016-09-10
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:
I would get:
(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!