Creating Summary Report in another Worksheet

Let's assume you have the sample data in A1:B6. You can very simply count the occurrences of a particular Type using the formula =COUNTIF("A1",$A$2:$A$6).
If you have a large number of Hardware Types, you can create a list of unique types with Data -> Filter -> Advanced Filter, and select the "Unique records only" checkbox, then substitute "A1" in the formula above with a reference to that list.
VBA will help if you want this summary to update automatically with every change, but it's simple enough to update periodically by hand that you may not want to bother.
HTH HAND

I don't want a list of just unique types, I want to create a list the contains one entry for each different type. Then I want to count how many of each type there were. Sorry, I know the verbage is a little strange. Hopefully this example will clarify.

So if my original list is:
A
A
A
B
B
A
B
X
X
Y

I want my new list to be:
A 4
B 3
X 2
Y 1

I would also love for this to update automatically if that isn't extremely difficult.

Like this?

create a list of unique types with Data -> Filter -> Advanced Filter, and select the "Unique records only" checkbox

Click to expand...

was included as an easy way to get the values in C1:C4 above, which then serve as the criteria for the formulae in D1:D4.

As far as updating, the Countif formula will recalculate any changes to the existing table, but if you extend that table - say you add entries at rows 11, 12, 13 ... - you'll need then to update the formula to reflect the new extent of the table. You may be able to forego this by setting the count range to the bottom of your sheet, or some other arbitrarily distant point.
Also, adding new unique values - e.g. "C" or "Z" - will require you to update the criteria table and copy the Countif formula.
I don't know how large your data set is, or if you'll need to consider the above factors at all. This was the quickest and simplest solution to your problem as stated. If you're updating this list every day, adding new rows of data and new unique parts, it may be worth spending a little more time at the outset.

Hi Zack,

A Pivot table is the easiest way to deal with this.

Have a look at this..

Kris

zrwolf said:

I don't want a list of just unique types, I want to create a list the contains one entry for each different type. Then I want to count how many of each type there were. Sorry, I know the verbage is a little strange. Hopefully this example will clarify.

So if my original list is:
A
A
A
B
B
A
B
X
X
Y

I want my new list to be:
A 4
B 3
X 2
Y 1

I would also love for this to update automatically if that isn't extremely difficult.

Click to expand...

Formulas...

B2 must house a 0.

B3, copied down:

=IF((A3<>"")*ISNA(MATCH(A3,$A$2:A2,0)),LOOKUP(9.99999999999999E+307,$B$2:B2)+1,"")

E1:

=LOOKUP(9.99999999999999E+307,B:B)

E3, copied down:

=IF(ROW()-ROW(E$3)+1<=$E$1,INDEX(A:A,MATCH(ROW()-ROW(E$3)+1,B:B)),"")

F3, copied down:

=IF(E3<>"",COUNTIF(A:A,E3),"")