Return a list of Occurrences

[janut24]

I have a list of outages at our cell sites. It is an Excel Spreadsheet with 1
row of dat per outage. The spreadsheet has 1 month of data and could be over
200 lines. I'd like to create a formula that will tell me how many outages
were at any given site. Now, we have over 300 sites and not everyone of them
has an outage. Is there a formula that will review the data and return
something like:
Casco 3
Brussels 2
Abrams 4
Where the number would be how many times an outage occured at that site. I
only want to see sites with more than 1 outage in a month.
Any help would be appreciated (I've been pouring over help sites for hours!)

 

[Chip Pearson]

A Pivot table could do this. Or, suppose you have a list of sites in
A1:A300. Then, you could use

=COUNTIF(DataSheet!C$1:C$200,A1)

and fill down from A1 through A300.

In this formula, it assume that: 1) DataSheet is the name of the
worksheet that lists the outages, and 2) that the sites on DataSheet
are listed in cells C1:C200. COUNTIF returns the number of items in
DataSheet!C1:C200 whose value is equal to A1. When you fill the
formula down the column, Excel will change the A1 to A2 then A3 and so
on down the range.


Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)