ctackett6407
Board Regular
- Joined
- Mar 18, 2018
- Messages
- 66
- Office Version
- 365
- Platform
- Windows
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
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