Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected cells and grouping | Excel Discussion (Misc queries) | |||
worksheet tabs do not respond to grouping | Excel Discussion (Misc queries) | |||
MAX formula for alphabetical letters | Excel Discussion (Misc queries) | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Date Format Pivot Grouping | Excel Discussion (Misc queries) |