Hi I have a column A with sales people and B with Location.
Line items represent customers, so a sales person will appear many times in
the data set.

I would like column C to return the most frequently occuring location for a
particular sales person, and D to return the number of occurences of that
location.

E should return the second most frequently occuring location, and F the # of
occurences.

Any suggestions?

Thanks.
singh