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:
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,
Bookmarks