Alphabetical Grouping
 

I have a list that is sorted alphabetically. Is it possible in Excel to make
an outline where you have A-Z tabs instead of 1, 2, 3... so that you can just
see the first company beginning with A and not the next 10 and then first
company beginning with B etc. Thanks.

Alphabetical Grouping
 

Assuming your names start in A2, with a header row etc.
You could insert a 1 character wide column before the names, and in
(the new) cell A2 insert the formula

=IF(LEFT(B2,1)=LEFT(B1,1),"","F")

Make the column font white-on-white to hide the data, and Data, Filter,
Auto-Filter. Selecting 'F' will give you the first of a group.

Note, if you have no header row you will either have to inser one or
type the letter 'F' into A1.

--

non lo so Wrote:
I have a list that is sorted alphabetically. Is it possible in Excel to
make
an outline where you have A-Z tabs instead of 1, 2, 3... so that you
can just
see the first company beginning with A and not the next 10 and then
first
company beginning with B etc. Thanks.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531639