Outline

[jc]

I have a sheet with NO calculations. I would like to
manually outline (I am new at this feature) so repetitive
data collapses. Let's say my data looks like this:

Acme Co. North
Acme Co. North
Acme Co. South
Badge Corp.
Badge Corp.
Chicago Loop
Chicago Loop

I want it to collapse to show only unique names, like
below.
+Acme Co. North
Acme Co. South
+Badge Corp.
+Chicago Loop

When I manually outline each group, they all combine to
one big group. Any hints?

 

[svtruck]

How about using the subtotal feature from the data menu?

Just select "count" of "co. name" or whatever.

 

[jc]

I have no calculations. Are you saying I can subtotal text?

Also, I am doing this manually.

 

[Dave Peterson]

Take a look at the things that =subtotal() can do in help. One of them is
counta.

=subtotal(3,a2:a99)

Would give you a count of how many times Acme Co. North appears. (Make sure
your data is sorted nicely before you start.)