Hello,

I've used advanced filtering to give me the unique values in column F and have those values displayed in column M using the code below.

    Columns("F:F").AdvancedFilter Action:=xlFilterCopy, CopyToRange:=Columns( _
        "M:M"), Unique:=True
I would now like to use VBA to display a "countif" for the number of instances each value that's in column M appears in column F. I know that's kind of an awkward sentence but I couldn't think of a better way to word it.

Example:

Column F Column M Column N
Jon Jon 2
Jon Sally 3
Sally Jen 1
Sally Mike 2
Sally Sam 2
Jen
Mike
Mike
Sam
Sam


Any ideas? Thanks for your help!