Seeking help for tracking

[zahirbd]

Thanks excel forum & its mentors to give us opportunity for taking support from excel legends. I have attached an excel file whereas 3 columns is kept. First column is for employees (many employees are here), second is for their staying time and third is for their staying area. Each person move many places during their office time. I want to know how many places each employee visit during office time; example one person visit tokyo one time and yokohama two times during his office hour. So result will be appeared in another columns as "2" (because he visits only two places, frequency is not a matter). Could any expert help me here to find out the result.

[jeffreybrown]

I think what you are asking would be best done with a Pivot Table.

[zahirbd]

Dear Jeff,
It's working. Rocks! Thanks for your support.

[jeffreybrown]

You are very welcome and thanks for the feedback and rep.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.