Macro to capture/count data in a column

[ctackett6407]

Good Morning!

I'm tryig to figure out how to create macro that will review a column and list and count values in the field.

Example

The Column will hav "Unit" as defned by House, Apartment, Barn, whatever.

My goal is to try to run something that go through the column and capture all values of like names and count them.

Unit (Column Header)
House
Apartment
Apt
Hus
Barn
Brn
Blah
Blah
Blah

and the output would be

House 1
Apartment 1
Apt 1
Hus 1
Barn 1
Brn 1
Blah 3

 

[jmacleary]

Hi there.

It looks like a pivot table will do exactly what you want.

Just create a new pivot table, choose your range as the data source, and then drag the column header into the row labels area, and drag it again into the values area.

	L	M	N	O	P	Q	R	S
13
14		Unit (Column Header)				Row Labels	Count of Unit (Column Header)
15		House				Apartment	1
16		Apartment				Apt	1
17		Apt				Barn	1
18		Hus				Blah	3
19		Barn				Brn	1
20		Brn				House	1
21		Blah				Hus	1
22		Blah				Grand Total	9
23		Blah
24

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:64px;"><col style="width:92px;"><col style="width:203px;"><col style="width:64px;"></colgroup><tbody>
</tbody>

You should get something like the above.