Outline

  • Thread starter Thread starter jc
  • Start date Start date
J

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?
 
How about using the subtotal feature from the data menu?

Just select "count" of "co. name" or whatever.
 
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.)
 
Back
Top