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!
Bookmarks