Using Countif on a variable list
Posted by Tony on April 05, 2001 3:09 AM
This is probably a simple one but....
I have a list of values which I want to total. The problem is that the list can change from day to day and I need to run this daily. I know I can use countif when I know what values to look for, but what I want to do is scan through the list and extract one of each value first. What I want to get is the total count of each value.
Results: JOE 1