VBA to List each count of instances of a given value in another column

You could do it through arrays or collections, but this should be a bit easier to follow:

Please Login or Register  to view this content.

Sure, no problem at all.

Referring to first block, I'm simply telling excel via the Set syntax of the Range object, what to refer to later in the code. In this case, Column M represents the result of your 'unique' filter. End(xlDown) simply replicates hitting Shift+Down on your keyboard when within the application itself. So long as there are no blanks, it is a way to define a range by selecting the first cell and letting Excel find the last. I then repeated this for the "F" column values. We now have two ranges to work with.

The second piece basically says, for each cell in the range containing only my unique names ("rngUnique" via Set rngUnique described above), perform the function countif, with the unique name as argument and the complete, raw, non-filtered range as the range to be queried. Assign the result of the countif to a Long variable. Then, in the cell one to the right of the unique name (Column N), place the value contained in the Long variable.

I suppose this 2nd piece could be streamlined to:

Please Login or Register  to view this content.

which would lessen the code by one line and the use of one variable, which if not to reused over and over again, is likely the better practice.

Hope this helps,