Hi, see enclosed file. in the file in cols a and b..........are what my input file looks like. THe other cols to the right are what i want my output to look like.
Basically, i have two cols...one a "protocol" col and another a "site" col.
I want to know for a given protocol what is the number of "unique" sites.
Note: I would like to use vba to do this as i am reading in the file and i just want to process it........
Note: I also am familiar with dictionaries if you want to use them but i could not figure out how to use them in this case.
Bookmarks