Collecting data from auto- generated excel file

Originally Posted by FDibbins

If you just want to count all the categories, create a small table like this...

	H	I
1	Assay	1
2	BUN	35
3	Cholesterol	62
4	Creatinine	67
5	Glucose	193
6	HDL	25
7	LDL	19
8	Raw Abs	476
9	Triglycerides	34
10	Uric Acid	41

I1=COUNTIF($B$2:$B$1478,H1) copied down

If you want this on another sheet, the formula would be...
=COUNTIF('Test%20Result(1)(1)'!$B$2:$B$1478,A1)

But why to use 1476
what to do if the file is more extended and contains much further rows?