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