Johnatha
11-27-2015, 12:42 PM
Hello,
I would like to know a simple macro that can count the number of cells in a certain column containing a certain value. Then, place that count on a cell on somewhere on my active worksheet. For example, count the number of cells in column 3 containing the word "ABSB" then place that count in a cell somewhere (see example table below).
Thanks
date
place
thing
person
21
alabama
ABSB
jim
22
alabama
ABSB
fred
20
alabama
ABSB
george
26
philly
CD
Jeremy
I would like to know a simple macro that can count the number of cells in a certain column containing a certain value. Then, place that count on a cell on somewhere on my active worksheet. For example, count the number of cells in column 3 containing the word "ABSB" then place that count in a cell somewhere (see example table below).
Thanks
date
place
thing
person
21
alabama
ABSB
jim
22
alabama
ABSB
fred
20
alabama
ABSB
george
26
philly
CD
Jeremy