Lookup and Count I think

[Steve]

I have a list of flight that our company has flown so
far this year. What i would like to do is set a program
that will go through and give me a result with a list of
all the cities and the amount of time we have gone into
that city. I appreciate any help I can get.

Thanks,
Steve

 

[Charles]

Steve,


Just a thought try using a pivot table. If set right it should give yo
the information you are looking for.



Charle

 

[scrabtree23]

Here is a link I found helpful:

http://www.j-walk.com/ss/excel/tips/tip74.htm